https://sudonull.com/collapsingmergetree-in-clickhouse-update-without-update
How CollapsingMergeTree and VersionedCollapsingMergeTree replace UPDATE in ClickHouse: sign column, collapsing pairs, SUM(amount*sign), ordering problem and solution via versions.