[GitHub] [spark] maropu commented on a change in pull request #32129: [SPARK-35028][SQL] ANSI mode: disallow group by aliases

[GitBox <gi...@apache.org>]

maropu commented on a change in pull request #32129:
URL: https://github.com/apache/spark/pull/32129#discussion_r612007345



##########
File path: docs/sql-ref-ansi-compliance.md
##########
@@ -183,6 +183,7 @@ The behavior of some SQL functions can be different under ANSI mode (`spark.sql.
 The behavior of some SQL operators can be different under ANSI mode (`spark.sql.ansi.enabled=true`).
   - `array_col[index]`: This operator throws `ArrayIndexOutOfBoundsException` if using invalid indices.
   - `map_col[key]`: This operator throws `NoSuchElementException` if key does not exist in map.
+  - `GROUP BY`: aliases in a select list can not be used in GROUP BY clauses. Each column referenced in a GROUP BY clause shall unambiguously reference a column of the table resulting from the FROM clause.

Review comment:
       nit: `in a GROUP BY clause` -> `by a GROUP BY clause`?




-- 
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.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org