The fastest open-source analytical database.

ClickHouse is a column-oriented database that enables its users to generate powerful analytics, using SQL queries, in real-time.

Blazing fast

Processes analytical queries faster than traditional row and column oriented systems.

Linearly scalable

Scales efficiently with hardware resources horizontally and vertically to petabyte scale.

Highly reliable

Supports asyncronous replication and can be deployed across multiple datacenters.

Flexible architecture

Supports shared-nothing clusters as well as separation of storage and compute.

Feature-rich

The most complete analytical database with support for joins, federated queries, and more.

Easy to use

Simplifies writing queries with a user-friendly SQL dialect, optimized for common analytical use cases.

Hardware efficient

ClickHouse processes analytical queries 100-1000x faster than traditional row-oriented systems with the same available I/O throughput and CPU capacity. Columnar storage format allows fitting more hot data in RAM, which leads to shorter response times.

Vectorization

Maximizes CPU efficiency

Vectorized query execution leverages SIMD processor instructions and runtime code generation. Processing data in columns increases CPU cache line hit rate.

Locality

Optimizes disk access

ClickHouse minimizes the number of seeks for range queries to increase efficiency of using disk drives and maintain locality of reference for continually stored data.

Throughput

Minimizes data transfers

ClickHouse enables companies to manage their data and create reports without using specialized networks that are aimed at high-performance computing.

From your laptop to petabyte scale

ClickHouse scales well both vertically and horizontally. It is easily adaptable to perform on your laptop, small virtual machine, a single server, or a cluster with hundreds or thousands of nodes.

There are many ClickHouse clusters consisting of multiple hundreds of nodes, while the largest known ClickHouse cluster is well over a thousand nodes. There are installations of ClickHouse with more multiple trillion rows or hundreds of terabytes of data per single node.

ClickHouse at scale

ClickHouse is used in a variety of industries for a broad set of use cases on top of both customer-facing and internally-facing workloads.

Web and app analytics

E-commerce and finance

Time series

Advertising networks and RTB

Information security

Business intelligence

Telecommunications

Monitoring and telemetry

Online games

Internet of Things (IoT)

Observability

User behavior analytics

Start using ClickHouse in minutes

Install ClickHouse for MacOS, Linux, and FreeBSD.

curl https://clickhouse.com/ | sh

Or install for Windows, Docker or see other install options.

Watch this getting started video to learn more about ClickHouse.

Products

Resources

Company

Join our community

Comparisons

Stay informed on feature releases, product roadmap, support, and cloud offerings!

Loading form...

Trademark Privacy Security Legal Cookie policy