Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

    enabledSet 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.

...