Explanation:
The query will result in an error because the _change_type column is reserved for Change Data Capture (CDC). The error message will be:
Error in SQL statement: DeltaIllegalStateException: Unable to enable Change Data Capture on the table. The table already contains reserved columns [_change_type] that will be used internally as metadata for the table’s Change Data Feed. To enable Change Data Feed on the table rename/drop these columns.
Error in SQL statement: DeltaIllegalStateException: Unable to enable Change Data Capture on the table. The table already contains reserved columns [_change_type] that will be used internally as metadata for the table’s Change Data Feed. To enable Change Data Feed on the table rename/drop these columns.
This means the Delta table cannot be created as is because of the conflict with reserved column names required for CDC functionality.
Ultimate access to all questions.
No comments yet.
A data engineer is creating a Delta table with the following SQL query:
CREATE TABLE data_changes (_change_type STRING, _changed_by STRING)
TBLPROPERTIES (delta.enableChangeDataFeed = true);
CREATE TABLE data_changes (_change_type STRING, _changed_by STRING)
TBLPROPERTIES (delta.enableChangeDataFeed = true);
What will be the outcome of executing this query?
A
The Delta table will be created successfully with the Change Data Feed enabled.
B
The SQL statement will result in an error and the Delta table will not be created.
C
The Delta table will be created successfully but Change Data Feed will not be enabled.
D
The Delta table will be created successfully but the _change_type column will be removed.
E
The SQL statement will not return any error but the Delta table will not be created.