|
|
|
A new SQL syntax allows specifying the dynamic list of partitions when running queries on dynamic partitioned files. The SQL grammar has been extended to support a new way of specifying the table name for SQL queries as follows:
table_ref ::
table_name [ AS ] [ alias [ ( column_alias [ , ... ] ) ] ]
| ( query_expression ) [ AS ] alias [ ( column_alias [ , ... ] ) ]
| [ ( ] joined_table [ ) ]
| FILESET(table_name [,"file_list"])[ AS ] [ alias [ ( column_alias [ , ... ] ) ] ]
If the same partitioned file is opened within two different FILESET lists, they are considered as separate files.
