DigiNews

Tech Watch by Johan Denoyer

← Back to articles

An Aggregate Is a Function, Not a Sum

Quality: 8/10 Relevance: 9/10

Summary

The article argues that aggregates can be treated as functions of their underlying documents rather than running sums, addressing duplicates, late arrivals, and outages in streaming workloads using a cell-based recomputation design in ClickHouse. It describes narrow tables, a dirty-cell journal, and ReplacingMergeTree to enable recomputation and scalable, correct reports without double counting.

🚀 Service construit par Johan Denoyer