ClickHouse
More info
- Creator
- Yandex (Aleksey Milovidov et al.)
- Released
- Owner
- ClickHouse Inc.
- Type
- Columnar OLAP database
- License
- Apache 2.0
- Website
- clickhouse.com
- Source
- github.com/ClickHouse
- Wikipedia
- en.wikipedia.org
Columnar OLAP database built for billion-row analytics — written in C++, originally for Yandex.Metrica.
Runs aggregates over billions of rows in seconds thanks to columnar storage, vectorised execution and aggressive per-column compression (LZ4/ZSTD). Supports SQL with heavy extensions (arrayJoin, materialised views, AggregatingMergeTree). Not for OLTP — lacks full ACID and updates/deletes are expensive.
Competes with Druid, Pinot and now DuckDB. Open source since 2016, commercialised by ClickHouse Inc. (2021). Common pick for observability backends (logs, metrics, traces).