...
The following limitations apply to creating datasets from a single statement.
All single-statement SQL queries must begin with a
SELECT
keyword.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.
Users are encouraged to provide fully qualified path to table being used. Example:
Code Block SELECT "id", "value" FROM "public"."my_table"
- You should use proper escaping in SQL.
...
D s config 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.
...