The MergeTree Family

Judgment

Learn the specialized MergeTree variants and build a decision framework for choosing among them.

What this module covers

ReplacingMergeTree (dedup on merge, not on insert)
SummingMergeTree
AggregatingMergeTree and the AggregateFunction column type
CollapsingMergeTree and VersionedCollapsingMergeTree (sign-column pattern)
Replication (ReplicatedMergeTree, ClickHouse Keeper)
Projections (alternative physical layouts)
MergeTree engine family decision framework

Lessons