Hacker News AIT2·Tools
72 pts
The author recounts four attempts at building real-time sales-receipt reports on Kafka and ClickHouse, showing that at-least-once delivery duplicates and late-arriving backlog break any aggregate defined as a running sum of inserts. The fix is to treat an aggregate as a function over its document set, so duplicates and late documents trigger recomputation instead of manual correction.