[SPARK-45806] GROUP BY ALL don't work in ansi mode

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 3.4.0, 3.5.0
• Component/s: SQL
• Assignee: Unassigned
• Reporter: XiaozongCui
• Created: 06/Nov/23 13:26
• Updated: 06/Nov/23 13:29

Description

I noticed that we treat 'ALL' in 'GROUP BY ALL' as an Identifier in parsing, and this will cause problem when I turn on ansi keyword behavior
set spark.sql.ansi.enabled=true;
set spark.sql.ansi.enforceReservedKeywords=true;

spark-sql (default)> select a,b,c, count from values(1,2,3)t(a,b,c) group by all;

[PARSE_SYNTAX_ERROR] Syntax error at or near 'all'.(line 1, pos 59)

== SQL ==
select a,b,c, count from values(1,2,3)t(a,b,c) group by all
-----------------------------------------------------------^^^

can we allow this reserved keyword in ansi mode ?

Issue Links

• relates to: SPARK-41635 GROUP BY ALL