[ https://issues.apache.org/jira/browse/SPARK-35028?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Apache Spark reassigned SPARK-35028: ------------------------------------ Assignee: Gengliang Wang (was: Apache Spark) > ANSI mode: disallow group by aliases > ------------------------------------ > > Key: SPARK-35028 > URL: https://issues.apache.org/jira/browse/SPARK-35028 > Project: Spark > Issue Type: New Feature > Components: SQL > Affects Versions: 3.2.0 > Reporter: Gengliang Wang > Assignee: Gengliang Wang > Priority: Major > > As per the ANSI SQL standard secion 7.12 <group by clause>: > bq. Each <grouping column reference> shall unambiguously reference a column > of the table resulting from the <from clause>. A column referenced in a > <group by clause> is a grouping column. > By forbidding it, we can avoid ambiguous SQL queries like: > SELECT col + 1 as col FROM t GROUP BY col -- This message was sent by Atlassian Jira (v8.3.4#803005) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org