MergeTree table engine family

Internals:

https://github.com/ClickHouse/clickhouse-presentations/blob/master/meetup41/merge_tree.pdf

https://youtu.be/1UIl7FpNo2M?t=2467


CollapsingMergeTree vs ReplacingMergeTree

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

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

AggregatingMergeTree

index & column files

Merge performance and OPTIMIZE FINAL

Merge performance and OPTIMIZE FINAL DEDUPLICATE BY expr

Nulls in order by

ReplacingMergeTree

Skip index

SummingMergeTree

UPSERT by VersionedCollapsingMergeTree

How to aggregate mutating event stream with duplicates