Fast Open-Source OLAP DBMS - ClickHouse

image

ClickHouse Product Screenshot

Build real-time data products that scale

Sony, Lyft, Cisco, GitLab, Twilio and many more choose ClickHouse Cloud for its scale, efficiency, and ease of use.

Filter by

“ClickHouse helps us efficiently and reliably analyze logs across trillions of Internet requests to identify malicious traffic and provide customers with rich analytics.” Read blog

1.5T

Page views analyzed / mo

2.5B

Visitors analyzed / mo

11M

Rows ingested / sec

“We needed something to slice and dice real-time data, like rides and driver hours across cities and regions where Lyft runs. Using ClickHouse resulted into a lot of performance benefits for us with huge cost savings for the org.” Read blog

10M+

Rows ingested daily

20TB

Data read daily

Huge

Cost savings

“In the post-evaluation of each database against our criteria (with metrics ranging from query performance to cost), ClickHouse emerged as the unrivalled frontrunner. It excelled across the board, even astonishingly so in certain domains, and proved more cost-efficient.” Read blog

100B+

Sessions analyzed / year

10x

Improved query speed

2-3x

Better storage efficiency

Why ClickHouse?

ClickHouse is the fastest and most resource efficient real-time data warehouse and open-source database.

Blazing fast

Ultimate query performance that your mission-critical and time-sensitive applications can depend on.

Developer friendly

Built to ensure that even the most sophisticated data analysis can be done intuitively, using simple SQL.

Cost effective

Best-in-class compression ratios

that reduce storage and accelerate

performance.

Open Source

More ->

Secure, compliantMore ->

Resource optimizedMore ->

Proven at scaleMore ->

100+ integrationsMore ->

Get started in a few minutes with a free cloud trial ->

Seamlessly integrate with your stack

Choose from our growing ecosystem of integrations for data ingestion, visualization, language clients, and more.

image

Stack integration graph

Why is ClickHouse so fast?

Column-oriented databases are better suited to OLAP scenarios. They are at least 100x faster in processing most queries. ClickHouse uses all available system resources to their full potential to process each analytical query as fast as possible.

Row-oriented databases

In row-oriented databases, data is stored in rows, with all the values related to a row physically stored next to each other.

Column-oriented databases

In column-oriented databases, like ClickHouse, data is stored in columns, with values from the same columns stored together.

Deploy your way

Unlike traditional closed-source databases, ClickHouse runs in every environment, whether it’s on your machine or in the cloud.

ClickHouse Cloud

The best way to use ClickHouse. Available on AWS, GCP, Azure and, on their respective marketplaces.Get started

Spin up a database server with open-source ClickHouse. Always free.Download ClickHouse

ClickHouse LocalRun fast queries on local files (CSV, TSV, Parquet, and many more) without a server.Download ClickHouse Local

Join the 100k+ developers using ClickHouse today

1.3k+Contributors

36k+PRs

36.7k+Stars

FAQs

Wherever you need us, we’re there. We love to engage in thoughtful conversation with the ClickHouse community and are always on-hand to answer your questions.

Ask us anything

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.