Applies to: Databricks SQL Databricks Runtime 11.0 and above
Reorganize a Delta Lake table by rewriting files to purge soft-deleted data, such as the column data dropped by ALTER TABLE DROP COLUMN.
REORG TABLE table_name [WHERE predicate] APPLY (PURGE)
REORG TABLE only rewrites files that contain soft-deleted data.
REORG TABLE is idempotent, meaning that if it is run twice on the same dataset, the second run has no effect.
After running REORG TABLE, the soft-deleted data may still exist in the old files. You can run VACUUM to physically delete the old files.
Identifies an existing Delta table. The name must not include a temporal specification.
Reorganizes the files that match the given partition predicate. Only filters involving partition key attributes are supported.
Specifies that the purpose of file rewriting is to purge soft-deleted data. See Purge metadata-only deletes to force data rewrite.