Apache-2.0
ClickHouse
Columnar analytics database for fast OLAP queries
An open-source column-oriented database aimed at high-performance analytical workloads and large-scale event data.
In depth
What it is
ClickHouse is an open-source column-oriented database aimed at high-performance analytical workloads and large-scale event data.
Key features
- Columnar storage - Columnar engine optimized for analytics scans.
- SQL - SQL interface with analytics-oriented extensions.
- Compression - High compression and fast aggregate queries.
- Distributed mode - Sharding and replication for scale-out analytics.
Strengths
- Columnar storage - Columnar engine optimized for analytics scans.
- SQL - SQL interface with analytics-oriented extensions.
- Compression - High compression and fast aggregate queries.
Trade-offs
- OLTP fit - Not designed for high-concurrency transactional workloads.
- Operations - Schema design, merges, and tuning affect performance and cost.
- Consistency - Replication and distributed queries add operational complexity.
Pricing
Open-source software. Direct license cost is zero; costs are typically infrastructure, operations, and optional paid support or hosting.
Explore alternatives
