[SPARK-48740] Catch missing window specification error early

• Type: Task
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 4.0.0
• Fix Version/s: 4.0.0
• Component/s: Spark Core
• Labels: pull-request-available
• Assignee: Amanda Liu
• Reporter: Amanda Liu
• Created: 27/Jun/24 18:44
• Updated: 30/Jul/24 00:35
• Resolved: 30/Jul/24 00:35

Description

Before, aggregate queries containing a window function without a window specification (e.g. `PARTITION BY`) would return a non-descriptive internal error message: 

`org.apache.spark.sql.catalyst.analysis.UnresolvedException: [INTERNAL_ERROR] Invalid call to exprId on unresolved object SQLSTATE: XX000`

This PR catches the user error early and returns a more accurate description of the issue:

`Window specification <windowName> is not defined in the WINDOW clause.`

Issue Links

• links to: GitHub Pull Request #47129