Introduction Deletion and updating the records are common on transactional databases. ClickHouse supports deletes and updates in MergeTree table engine via the ALTER TABLE … statement. They are also known as Mutations which happen asynchronously … Continue reading ClickHouse MergeTree: Deletes and Updates with CollapsingMergeTree