All ClickHouse Books
4Designing Data-Intensive Applications
O'Reilly
Not a ClickHouse book — but the chapters on column-oriented storage, OLAP vs OLTP, and distributed systems fundamentals give you the mental model that makes ClickHouse design decisions legible. Read chapters 3 and 6 in particular.
Database Internals
Alex Petrov · O'Reilly · 370 pages · ~9 hrs to read
Not ClickHouse-specific, but the column-oriented storage and vectorised execution chapters explain the mechanics that make ClickHouse's MergeTree engine fast. Read this to understand why ClickHouse makes the schema-design tradeoffs it does, not just what the syntax is.
Streaming Systems
Tyler Akidau, Slava Chernyak & Reuven Lax · O'Reilly · 351 pages · ~9 hrs to read
Relevant for the Kafka-to-ClickHouse real-time ingestion pattern that most production ClickHouse deployments run. Not about ClickHouse directly, but useful once you're feeding it from a streaming source rather than batch loads.
Fundamentals of Data Engineering
Joe Reis & Matt Housley · O'Reilly · 446 pages · ~11 hrs to read
Places OLAP columnar engines like ClickHouse within the broader landscape of warehouse and lakehouse choices. Useful context for deciding when ClickHouse is the right analytical engine versus Snowflake or BigQuery.
ClickHouse resources