How to Compute a Running Aggregation in ClickHouse - видео

Using aggregate functions in a materialized view in ClickHouse can lead to surprising results if you dont define them properly. The AggregatingMergeTree table engine requires special column types for representing and storing intermediate running totals of aggregations like avg max min uniq count and all the other aggregate functions in ClickHouse. Reference links: Get Started Today: AggregatingMergeTree table engine Documentation: The SimpleAggregateFunction data type: ClickHouse Academy: ,
Источник видео: RuTube.ru (Технологии и интернет)