ClickHouse is an open-source, columnar, OLAP(Online Analytical Processing) database designed for extremely fast analytical queries on large data volumes.
Popular fields deployed in: ad-tech, IoT, BI and more.
ClickHouse is fast because:
- Columnar Storage.
- Vectorized Execution.
- Data Compression.
- Skip Indexes.
- Multi-threaded by default.
- Merge Tree Engine.
Key architectural concepts:
a) MergeTree Tables.
b) Distributed Tables.
c) Materialized Views.
d) Time To Live(TTL).
Facebook Comments