Rich Raposa Director, Global Learning, ClickHouse
Using aggregate functions in a materialized view in ClickHouse can lead to surprising results if you don't 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.
Stay informed on feature releases, product roadmap, support, and cloud offerings!
© 2023 ClickHouse, Inc. HQ in the Bay Area, CA and Amsterdam, NL.