v.1.1.54388New Feature

Support for ALTER TABLE DELETE Queries on Replicated Tables

Official CH changelog text
Support for the ALTER TABLE t DELETE WHERE query for replicated tables. Added the system.mutations table to track progress of this type of queries.
Added support for the ALTER TABLE t DELETE WHERE query on replicated tables and introduced the system.mutations table to monitor the progress of such mutations.

Why it matters

This feature enables users to perform delete operations on replicated tables using the ALTER TABLE ... DELETE WHERE syntax. It addresses the need to modify data in replicated environments consistently and provides visibility into the progress of these delete mutations via the new system.mutations table.

How to use it

Users can execute delete operations on replicated tables by running queries in the following form:

ALTER TABLE <table_name> DELETE WHERE <condition>


To track the progress of these delete mutations, users can query the system.mutations table:

SELECT * FROM system.mutations WHERE table = '<table_name>'
PreviousNext