ClickHouse® - What is Behind the Fastest Columnar Database?
summary
Explains why ClickHouse processes billions of rows and claims tens of GB/s by using columnar storage, per-column compression codecs, vectorized execution and a sparse primary index that skips roughly 8192-row blocks. Demo loads NYPL menu CSVs into Replicated MergeTree tables, queries aggregates and text-length trends, and shows Kafka integration via the Kafka table engine plus materialized views to move topic data into tables; warns it is poor for single-row OLTP or frequent updates.
AI-written summary · about
chapters (8)
- 0:00ClickHouse introduction
- 1:06Storing massive analytical data
- 4:42OLTP vs OLAP explained
- 7:59ClickHouse performance features
- 16:57Demo: restaurant menus data
- 27:49ClickHouse with Kafka
- 31:20Key considerations
- 33:07Resources and closing
related talks
42mClickHouse: what is behind the fastest columnar database
45mClickHouse: what is behind the fastest columnar database
51mWhat You Need to Know About ClickHouse Architecture
28mColumnstore Revolution
59mEffective Use of ClickHouse
26mColumnar Storage: Redefining Data Management for the Modern Era
26mHandling Large Volumes of Immutable Structured Data With ClickHouse
40mData warehouse or conventional database: Which is right for you?