v.22.8New Feature

Support SQL DELETE FROM Syntax for Merge Tree Tables in ClickHouse

Official CH changelog text
Support SQL standard DELETE FROM syntax on merge tree tables and lightweight delete implementation for merge tree families. #37893 (Jianmei Zhang) (Alexander Gololobov). Note: this new feature does not make ClickHouse an HTAP DBMS.
Adds support for the SQL standard DELETE FROM syntax on MergeTree tables along with a lightweight delete implementation for MergeTree table families.

Why it matters

This feature enables users to perform DELETE operations directly using standard SQL syntax on MergeTree tables, simplifying data removal workflows. It addresses the need for a more straightforward and efficient way to delete data in ClickHouse, improving usability without turning ClickHouse into a full HTAP (Hybrid Transactional/Analytical Processing) system.

How to use it

Users can delete data from MergeTree tables by executing standard SQL commands like: 
DELETE FROM table_name WHERE condition
. This works on MergeTree family tables and uses an optimized lightweight mechanism for data deletion.

Related resources

PreviousNext