DATASET_TABLE ( ON ( DATASET_instances_retrieving_expression ) [ USING ( { row_expression_literal | column_expression_literal } ) ] )
Only the AVRO storage format uses the row_expression_literal in the USING clause. CSV does not.
Syntax Elements
- Dataset_instances_retrieving_expression
- A query expression, table name, or view name that results in shredding DATASET instances.
- USING
- Input to the table operator as specified by Dataset_instances_retrieving_expression.
- row_expression_literal
- A LATIN or UNICODE string literal conforming to the dot notation syntax supported on the DATASET type. It must use the '$' prefix at the beginning, which represents the root of the DATASET instance. This parameter defines the set of data that creates the output rows.
- column_expression_literal
- A LATIN or UNICODE string literal conforming to the DATASET type dot notation syntax. It must use the '$' prefix at the beginning, representing the DATASET instance root, or the row expression result (depending on if the 'fromRoot' attribute is present). column_expression_literal defines output table columns, and which data populates the columns.