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.
ClickHouse Cloud, How to
LogHouse, Observability for ClickHouse Cloud
Get an insider’s look at LogHouse, the ClickHouse-powered logging platform that drives observability for ClickHouse Cloud.
ClickHouse, How to
Powering Feature Stores with ClickHouse
Mark Needham Principal Product Marketing Engineer, ClickHouse
How to
Querying archive files with ClickHouse
Mark Needham Principal Product Marketing Manager, ClickHouse
Follow us
Products
© 2025 ClickHouse, Inc. HQ in the Bay Area, CA and Amsterdam, NL.