MergeTree table engine family

CollapsingMergeTree vs ReplacingMergeTree

Part names & MVCC

Part names & multiversion concurrency control.

How to pick an ORDER BY / PRIMARY KEY / PARTITION BY for the MergeTree family table

Optimizing ClickHouse® MergeTree tables

AggregatingMergeTree

index & column files

Merge performance and OPTIMIZE FINAL

Nulls in order by

ReplacingMergeTree

Skip index

SummingMergeTree

UPSERT by VersionedCollapsingMergeTree

How to aggregate mutating event stream with duplicates