An Aggregate Is a Function, Not a Sum

7 points by alnovis

The article discusses four methods for maintaining report aggregates in ClickHouse, detailing the shortcomings of each approach. Ultimately, the chosen design involves recomputing cells from their original documents rather than simply summing them, which improves accuracy and reliability in handling data streams.

Read the article

Discussion on Hacker News