Vladimir Golubev created SPARK-49250:
----------------------------------------

             Summary: CheckAnalysis with UnresolvedWindowExpression nested 
inside other expressions produces confusing error message
                 Key: SPARK-49250
                 URL: https://issues.apache.org/jira/browse/SPARK-49250
             Project: Spark
          Issue Type: Improvement
          Components: SQL
    Affects Versions: 4.0.0
            Reporter: Vladimir Golubev


Consider the following query: `SELECT (SUM(col1) OVER(unspecified_window) / 1) 
FROM VALUES (1)`. Currently the resolution produces 
`org.apache.spark.sql.catalyst.analysis.UnresolvedException: [INTERNAL_ERROR] 
Invalid call to dataType on unresolved object SQLSTATE: XX000`, which is 
confusing. We need to change it to `ExtendedAnalysisException: 
[MISSING_WINDOW_SPECIFICATION]` 



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to