ClickHouse® is a fast, open-source column-oriented database management system that can generate analytical data reports through SQL queries in real time. According to several independent benchmarks, it far exceeds other comparable column-oriented database management systems, working even up to 1000 times faster. It is able to process hundreds of millions to more than a billion rows and tens of gigabytes of data per single server per second. Apart from its blazing speed, ClickHouse is highly reliable and fault tolerant. It supports multi-master asynchronous replication with the option of being deployed across multiple datacenters. With all nodes equal, there is no single point of failure. Downtime of a single node or even the whole datacenter won't affect the system's availability. ClickHouse also has exceptional hardware efficiency and a host of other features, including a feature-rich SQL database, vectorized query execution, real-time query processing and data ingestion, and more.
Features
- Amazingly fast
- Fault-tolerant and highly reliable
- Hardware efficient
- High availability
- Linearly scalable
- Easy to use
- True column-oriented storage
- Vectorized, parallel and distributed query execution
- Real-time query processing & data ingestion
- On-disk locality of reference
- Secondary data-skipping indexes
- Data compression
- Hot and cold storage separation
- SQL support
- JSON documents query functions
- Cross-datacenter replication
- Adaptive join algorithm
- Pluggable external dimension tables
- Focus on OLAP workloads
- Hadoop, MySQL, Postgres integration
- S3-compatible object storage support
- ...and more!
Project Samples
