Skip to content
ClickHouse Docs
ClickHouse DocsClickHouse Docs
49.6kGet Started

ALTER TABLE ... APPLY DELETED MASK

View as MarkdownEdit this pageReport an issueSet up docs MCP
ALTER TABLE [db].name [ON CLUSTER cluster] APPLY DELETED MASK [IN PARTITION partition_id]

The command applies mask created by lightweight delete and forcefully removes rows marked as deleted from disk. This command is a heavyweight mutation, and it semantically equals to query ALTER TABLE [db].name DELETE WHERE _row_exists = 0.

See also

Part of: ALTER

Navigation