Hacker News

oatsandsugar
ClickHouse table engines & CDC data (MergeTree, Replacing, Collapsing +) fiveonefour.com

oatsandsugarop6 hours ago

Author here: I wrote out some worked examples about how ClickHouse's table engines affect how CDC updates and deletes are treated (on initial write, and on merge), coming to the conclusion that the ReplacingMergeTree is the goldilocks table engine for most CDC use-cases.

hn-front (c) 2024 voximity
source