ClickHouse
ClickHouse is a column-oriented database built for OLAP — scanning and aggregating billions of rows fast. Covers MergeTree internals, querying, ingestion, scaling, and operations.
Column-oriented OLAP database
ClickHouse is a column-oriented database built for OLAP — scanning and aggregating billions of rows fast. Covers MergeTree internals, querying, ingestion, scaling, and operations.
- 10
- chapters
- 34
- sections
- 0
- figures
- 1Why ClickHouseWhat problem it solves, and when it's the wrong choice.1 sections0 figures
- 2FoundationsGet it running, write your first queries, and understand how a MergeTree table stores what you write.4 sections0 figures
- 3Data TypesChoosing the right shape for your data, including nested structures.2 sections0 figures
- 4Storage EngineHow ClickHouse actually stores rows on disk.3 sections0 figures
- 5SQL & QueryingJoins, windows, and the SQL features that behave differently here.4 sections0 figures
- 6Query SpeedThe tricks that make scans over billions of rows fast.5 sections0 figures
- 7Ingestion & Other EnginesGetting data in, and the engines beyond MergeTree.5 sections0 figures
- 8Security & BackupUsers, permissions, and not losing data.3 sections0 figures
- 9Scale & OpsRunning it across machines, safely, over time.3 sections0 figures
- 10Monitoring & OperationsWatching it run, tuning it, and what breaks in production.4 sections0 figures