...

The following limitations apply to creating datasets from a single statement. 

1. All single-statement SQL queries must begin with a SELECT keyword.

2. Selecting columns with the same name, even with "*", is not supported and generates an ambiguous column name error. 

   Tip
   Tip: You should use fully qualified column names or proper aliasing. See Column Aliasing below.

   
   

3. Users are encouraged to provide fully qualified path to table being used. Example:

   Code Block
   SELECT "id", "value" FROM "public"."my_table"

   
   

4. You should use proper escaping in SQL.

...

1. D s config

2. Locate the following setting:
   
   

   Code Block
   Enable custom SQL Query

   
   

   Setting	Description
   enabled	Set to true to enable the SQL pushdown featureability to create datasets using customized SQL statements. By default, this feature is enabled.

   
   

...

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.

...