cuixiaozong commented on PR #39134: URL: https://github.com/apache/spark/pull/39134#issuecomment-1794430313
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 ? -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
