ClickHouse Core
ClickHouse from the inside out. Why it exists, the one-binary architecture, the MergeTree family as a data model, parts/granules/marks, the sparse primary index, skip indexes, codecs and compression, materialized views, projections, async inserts, Distributed and ReplicatedMergeTree, joins, reading EXPLAIN PIPELINE, and the three settings that decide whether a query OOMs, spills, or runs. Ends with a capstone migration.
Course content
- 01Why ClickHouse ExistsFree
- 02ClickHouse Architecture🔒
- 03The MergeTree Family🔒
- 04Parts, Granules, Marks🔒
- 05The Sparse Primary Index🔒
- 06Skip Indexes🔒
- 07Codecs & Compression🔒
- 08Materialized Views🔒
- 09Projections🔒
- 10Async Inserts & Buffer Tables🔒
- 11Distributed Tables & Sharding🔒
- 12Replication with ReplicatedMergeTree🔒
- 13Joins in ClickHouse🔒
- 14Reading EXPLAIN PIPELINE🔒
- 15Tuning Memory & Settings🔒
- 16Capstone - Migrate a Workload to ClickHouse🔒
Prerequisites
Read the first chapter free
Start reading now — no account required for the free chapters.