- 1379 Views
- 1 replies
- 0 kudos
This SQL statement works fine by itself SELECT COUNT(1) FROM tablea f INNER JOIN tableb t ON lower(f.col1) = t.col1but if I want to use it inside a function:CREATE OR REPLACE FUNCTION fn_abc(var1 ...
- 1379 Views
- 1 replies
- 0 kudos
Latest Reply
Hello @Lily99 , I hope this message finds you well.
Could you please try the code below and let me know the results?
CREATE OR REPLACE FUNCTION fn_abc(var1 STRING, var2 STRING)
RETURNS DOUBLECOMMENT 'test function'RETURN SELECT CASE WHEN EXISTS...
- 4975 Views
- 3 replies
- 1 kudos
When I aggregate over more data, I get the below error message. I've tried multiple ways of diagnosis like going back to a version I know it was working fine (but still got the same error below). Please advise as this is a critical report where the b...
- 4975 Views
- 3 replies
- 1 kudos
Latest Reply
@Jeff Wu :The error message suggests that there is a syntax error in a SQL statement, specifically near the end of the input. Without the full SQL statement or additional information, it's difficult to pinpoint the exact cause of the error. However,...
2 More Replies
by
pc
• New Contributor II
- 3111 Views
- 4 replies
- 0 kudos
com.databricks.backend.common.rpc.DatabricksExceptions$SQLExecutionException: org.apache.spark.sql.AnalysisException: The query operator `UpdateCommandEdge` contains one or more unsupportedexpression types Aggregate, Window or Generate.Invalid expres...
- 3111 Views
- 4 replies
- 0 kudos
Latest Reply
Hi @Pradeep Chauhan Thank you for posting your question in our community! We are happy to assist you.To help us provide you with the most accurate information, could you please take a moment to review the responses and select the one that best answe...
3 More Replies
by
Kajorn
• New Contributor III
- 6682 Views
- 2 replies
- 0 kudos
Hi, I have trouble with executing the given SQL Statement below.MERGE INTO warehouse.pdr_debit_card as TARGET
USING (SELECT * FROM (
SELECT CIF,
CARD_TYPE,
ISSUE_DATE,
MATURITY_DATE,
BOO,
DATA_DATE,
row_number(...
- 6682 Views
- 2 replies
- 0 kudos
Latest Reply
Hi, Please refer: https://docs.databricks.com/sql/language-manual/delta-merge-into.html
1 More Replies
- 10098 Views
- 11 replies
- 10 kudos
Hi Everyone,I am getting the following error when running a SQL query and do not understand what it means or what can be done to resolve it. Any recommendations?View DDL:CREATE VIEW myschema.table (
accountId,
agreementType,
capture_file_name,
...
- 10098 Views
- 11 replies
- 10 kudos
Latest Reply
Hi @Michael Okulik Hope all is well! Just wanted to check in if you were able to resolve your issue and would you be happy to share the solution or mark an answer as best? Else please let us know if you need more help. We'd love to hear from you.Tha...
10 More Replies
- 8050 Views
- 3 replies
- 3 kudos
When i try to execute sql query(2 joins) i get below message: com.databricks.backend.common.rpc.DatabricksExceptions$SQLExecutionException: org.apache.spark.util.SparkFatalException
at org.apache.spark.sql.execution.exchange.BroadcastExchangeExec.$a...
- 8050 Views
- 3 replies
- 3 kudos
Latest Reply
@Erni Jed , I tested, and your query is ok. So it has to be some other issue. Maybe you could try it on a smaller data set. Please analyze/debug also using SPARK UI.
2 More Replies
