Problem

After executing the ​​ALTER TABLE {table} CLUSTER BY NONE command to remove the liquid clustering columns from the table, you then attempt to run SHOW CREATE TABLE  on your Delta table and receive the following 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. SQLSTATE: 0A000

Cause

The SHOW CREATE TABLE command is not supported for tables that have had their clustering columns removed using the ALTER command.

Solution

Use Databricks Runtime 15 or above, where the SHOW CREATE TABLE command is supported. 

If you do not want to update to Databricks Runtime 15 or above, you can drop the liquid clustering table feature.

1. Start an all-purpose compute cluster running Databricks Runtime 14.1 or above.
2. Attach a notebook to this cluster.
3. Run the following ALTER TABLE commands:

ALTER TABLE <your-catalog.your-schema.your-table> DROP FEATURE liquid
ALTER TABLE <your-catalog.your-schema.your-table> DROP FEATURE clustering

4. Shut down the cluster and switch back to your existing compute clusters.