[SPARK-48556] Incorrect error message pointing to UNSUPPORTED_GROUPING_EXPRESSION

• Type: Bug
• 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: Nikola Mandic
• Reporter: Nikola Mandic
• Created: 06/Jun/24 16:17
• Updated: 11/Jun/24 17:02
• Resolved: 11/Jun/24 17:02

Description

Following sequence of queries produces UNSUPPORTED_GROUPING_EXPRESSION error:

create table t1(a int, b int) using parquet;
select grouping(a), dummy from t1 group by a with rollup; 

However, the appropriate error should point the user to the invalid dummy column name.

Issue Links

• links to: GitHub Pull Request #46900