Issue with Liquid Clustering on Partitioned Table in Databricks

Akshay_Petkar
Valued Contributor

 

I recently tried applying Liquid Clustering to a partitioned table in Databricks and encountered the following

error: [DELTA_ALTER_TABLE_CLUSTER_BY_ON_PARTITIONED_TABLE_NOT_ALLOWED] ALTER TABLE CLUSTER BY cannot be applied to a partitioned table.

I understand that Z-Ordering works fine on non-partitioned columns, and I have successfully used. 

However, I specifically want to use Liquid Clustering instead of Z-Ordering. Since ALTER TABLE <TABLE NAME> CLUSTER BY (COLUMNS) is not supported on partitioned tables, has anyone found a workaround or an alternative approach to achieve similar clustering benefits?

Akshay Petkar