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.

Intermediate16 chapters· 4h 37m· in Query Engines & OLAP

Course content

  1. 01Why ClickHouse ExistsFree
  2. 02ClickHouse Architecture🔒
  3. 03The MergeTree Family🔒
  4. 04Parts, Granules, Marks🔒
  5. 05The Sparse Primary Index🔒
  6. 06Skip Indexes🔒
  7. 07Codecs & Compression🔒
  8. 08Materialized Views🔒
  9. 09Projections🔒
  10. 10Async Inserts & Buffer Tables🔒
  11. 11Distributed Tables & Sharding🔒
  12. 12Replication with ReplicatedMergeTree🔒
  13. 13Joins in ClickHouse🔒
  14. 14Reading EXPLAIN PIPELINE🔒
  15. 15Tuning Memory & Settings🔒
  16. 16Capstone - Migrate a Workload to ClickHouse🔒

Prerequisites

Read the first chapter free

Start reading now — no account required for the free chapters.