Liquid Cluster - SHOW CREATE TABLE error

[ss6]

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)

[Ayushi_Suthar · Accepted solution]

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