Chaining Materialized Views in ClickHouse
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
Language
English
Hacker News points
None found.