cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
cancel
Showing results for 
Search instead for 
Did you mean: 

Liquid Cluster - SHOW CREATE TABLE error

ss6
New Contributor

We've got this table with liquid clustering turned on at first, but then we switch off with below command.

ALTER TABLE table_name CLUSTER BY NONE;

Now, our downstream process that usually runs "SHOW CREATE TABLE" is hitting a snag. It's throwing this error:

"[DELTA_CLUSTERING_SHOW_CREATE_TABLE_WITHOUT_CLUSTERING_COLUMNS] SHOW CREATE TABLE is not supported for Delta table with Liquid clustering without any clustering columns."

Is there a way to fix this issue? (I do not want to recreate this table again)

1 REPLY 1

Ayushi_Suthar
Honored Contributor
Honored Contributor

Hi @ss6 , Hope you are doing well! 

We would like to inform you that currently, SHOW CREATE TABLE is not supported after running ALTER TABLE CLUSTER BY NONE.

This is a known issue and our Engineering team is prioritizing a fix to retain the clustering columns in coming releases.

https://docs.databricks.com/en/error-messages/error-classes.html#delta_clustering_show_create_table_...

As a workaround, you can use ALTER TABLE CLUSTER BY to add back those columns after creating the table.

 Please refer to this doc for more details : https://docs.databricks.com/en/delta/clustering.html#enable-liquid-clustering

Please let me know if this helps and leave a like if this information is useful, followups are appreciated.
Kudos
Ayushi

Welcome to Databricks Community: Lets learn, network and celebrate together

Join our fast-growing data practitioner and expert community of 80K+ members, ready to discover, help and collaborate together while making meaningful connections. 

Click here to register and join today! 

Engage in exciting technical discussions, join a group with your peers and meet our Featured Members.