REORG TABLE
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.
Syntax
REORG TABLE table_name [WHERE predicate] APPLY (PURGE)
Note
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.
Parameters
-
Identifies an existing Delta table. The name must not include a temporal specification.
WHERE
predicateReorganizes the files that match the given partition predicate. Only filters involving partition key attributes are supported.
APPLY (PURGE)
Specifies that the purpose of file rewriting is to purge soft-deleted data. See Purge metadata-only deletes to force data rewrite.