Guide56.5K views1,524 votes0 replies2,580 following
ClickHouse ReplacingMergeTree: append-only deduplication with FINAL and version columns
ReplacingMergeTree keeps ingestion append-only but does not enforce uniqueness at insert time. Use the sorting key as identity, a version column to choose the survivor, and FINAL only when immediate correctness matters.
clickhouse