The following limitations apply to creating datasets from a single statement.
All single-statement SQL queries must begin with a
Selecting columns with the same name, even with
"*", is not supported and generates an ambiguous column name error.
Tip: You should use fully qualified column names or proper aliasing. See Column Aliasing below.
Users are encouraged to provide fully qualified path to table being used. Example:
SELECT "id", "value" FROM "public"."my_table"
- You should use proper escaping in SQL.
D s config
Locate the following setting:
Enable custom SQL Query
trueto 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.
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.