HyukjinKwon commented on a change in pull request #27775: [SPARK-31022][SQL]
group by alias should fail if there are name conflicts
URL: https://github.com/apache/spark/pull/27775#discussion_r387411587
##########
File path: docs/sql-migration-guide.md
##########
@@ -341,6 +341,8 @@ license: |
- The decimal string representation can be different between Hive 1.2 and
Hive 2.3 when using `TRANSFORM` operator in SQL for script transformation,
which depends on hive's behavior. In Hive 1.2, the string representation omits
trailing zeroes. But in Hive 2.3, it is always padded to 18 digits with
trailing zeroes if necessary.
+ - Since Spark 3.0, group by alias fails if there are name conflicts like
`SELECT col + 1 as col FROM t GROUP BY col`. In Spark version 2.4 and earlier,
it works and the column will be resolved using child output. To restore the
previous behaviour, set `spark.sql.legacy.allowAmbiguousGroupByAlias` to `true`.
Review comment:
nit: like -> such as
----------------------------------------------------------------
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:
[email protected]
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
