[SPARK-44044] Improve Error message for SQL Window functions

• Type: Improvement
• Status: Resolved
• Priority: Trivial
• Resolution: Fixed
• Affects Version/s: 3.5.0
• Fix Version/s: 3.5.0
• Component/s: Structured Streaming
• Assignee: Siying Dong
• Reporter: Siying Dong
• Created: 13/Jun/23 18:44
• Updated: 01/Jul/23 05:51
• Resolved: 01/Jul/23 05:51

Description

Right now, if window spec is used with a stream query, the error message looks like following:
Non-time-based windows are not supported on streaming DataFrames/Datasets;
Window [... <Sub Logic Plan>
The message isn't very helpful to identify what's the problem is and some customers and even support engineers got confused by this. It is suggested that we call out aggregation function over the window spec so that the users can locate the part of the query that caused the problem easier.

Issue Links

• links to: [Github] Pull Request #41578 (siying)
• links to: [Github] Pull Request #41578 (siying)