[SPARK-49250] CheckAnalysis with UnresolvedWindowExpression nested inside other expressions produces confusing error message

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.0.0
• Fix Version/s: 4.0.0
• Component/s: SQL
• Labels: pull-request-available
• Assignee: Vladimir Golubev
• Reporter: Vladimir Golubev
• Created: 15/Aug/24 15:57
• Updated: 16/Aug/24 16:46
• Resolved: 16/Aug/24 16:46

Description

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]` 

Issue Links

• links to: GitHub Pull Request #47775