ClickHouse source code is published under the Apache 2.0 License. Software is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.

logo_without_text.svg

Stay informed on feature releases, product roadmap, support, and cloud offerings!

Subscribe to our newsletter

icon-github.svg

icon-slack.svg

icon-telegram.svg

icon-twitter.svg

Join the ClickHouse conversation on

ClickHouse

ClickHouse Cloud

Download

PRODUCT

Documentation

Training

Support

Comparison

Use cases

RESOURCES

Blog

Our story

Careers

Contact us

News and events

COMPANY

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.

Rich Raposa
Director, Global Learning, ClickHouse

How to Compute a Running Aggregation in ClickHouse

Linux, macOS, FreeBSD

This talk was given at the ClickHouse Community Meetup in Tel Aviv on January 16, 2023.

Doron Hoffman & Guram Sigua
Contentsquare

ClickHouse journey in Contentsquare

This is a re-recording of a talk that was given at the ClickHouse Community Meetup in Berlin on 5 December 5, 2022

Videos / User Stories

Big Sensitive Data Warehouse in regulated environments on ClickHouse

Pavel Yakunin Deutsche Bank

Recent videos