...
AWS Glue follows Hive syntax. See previous.
Column Aliasing
If your select statement results in multiple columns with same name, the query fails to validate or fails on execution, such as selecting all columns in a JOIN. In these cases, columns must be properly aliased.
...