Liquid Cluster - SHOW CREATE TABLE error

ss6 — Fri, 23 Feb 2024 20:24:51 GMT

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)

Re: Liquid Cluster - SHOW CREATE TABLE error

Ayushi_Suthar — Mon, 26 Feb 2024 04:57:33 GMT

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_without_clustering_columns

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

topic Liquid Cluster - SHOW CREATE TABLE error in Data Engineering

Liquid Cluster - SHOW CREATE TABLE error

Re: Liquid Cluster - SHOW CREATE TABLE error