v.24.9New Feature

Add Support for Lightweight Deletes in Partition

Official CH changelog text
Add support for lightweight deletes in partition DELETE FROM [db.]table [ON CLUSTER cluster] [IN PARTITION partition_expr] WHERE expr; #67805 (sunny).
Added support for lightweight deletes in partitions using the DELETE FROM syntax with the IN PARTITION clause to efficiently remove data within a specified partition.

Why it matters

This feature allows users to perform delete operations scoped to specific partitions without heavy data rewriting, improving delete performance and resource utilization when cleaning up data in large tables.

How to use it

Users can perform partition-level deletes with the following syntax:

DELETE FROM [db.]table [ON CLUSTER cluster] [IN PARTITION partition_expr] WHERE expr;

Specify the partition to target using IN PARTITION partition_expr and the rows to delete with the WHERE clause.

Related resources

PreviousNext