An analyst needs to enforce Liquid clustering on an existing unpartitioned Delta table named `transactions` using the `transaction_date` column. Which command should they run?

Question

Accepted Answer

B. ALTER TABLE transactions CLUSTER BY (transaction_date). To enable liquid clustering on an existing unpartitioned table, the correct syntax is `ALTER TABLE table_name CLUSTER BY (clustering_columns)`. This registers the clustering configuration. Note that existing data is not automatically reclustered; a subsequent OPTIMIZE (or OPTIMIZE FULL) run is needed to apply clustering to existing data. `OPTIMIZE ... ZORDER BY` is the older Z-order syntax, incompatible with liquid clustering. CTAS would recreate the table. ANALYZE computes statistics, not clustering.

An analyst needs to enforce Liquid clustering on an existing unpartitioned Delta table named `transactions` using the `transaction_date` column. Which command should they run?

Related Questions

Discussion

An analyst needs to enforce Liquid clustering on an existing unpartitioned Delta table named transactions using the transaction_date column. Which command should they run?

Related Questions

Discussion

An analyst needs to enforce Liquid clustering on an existing unpartitioned Delta table named `transactions` using the `transaction_date` column. Which command should they run?