/plushcap/analysis/clickhouse/chaining-materialized-views

Chaining Materialized Views in ClickHouse

What's this blog post about?

This text discusses the use of materialized views in ClickHouse, a distributed column-oriented DBMS. It explains how to create and chain multiple materialized views together for efficient data aggregation and transformation. The example provided demonstrates how to track unique users, pages, and total changes made on a minute-by-minute basis using the Wiki recent changes feed as a source of events. Additionally, it shows how to modify the existing setup to aggregate data in 10-minute intervals instead of one minute.

Company
ClickHouse

Date published
April 16, 2024

Author(s)
Mark Needham

Word count
1700

Hacker News points
None found.

Language
English


By Matt Makai. 2021-2024.