SELECT toStartOfMonth(upload_date) AS month, sum(view_count) AS `Youtube Views`, bar(sum(has_subtitles) / count(), 0.55, 0.7, 100) AS `% Subtitles` FROM youtube WHERE (month >= '2020-08-01') AND (month <= '2021-08-01') GROUP BY month ORDER BY month ASC
13 rows in set. Elapsed: 0.823 sec Processed 1.07 billion rows, 11.75 GB (1.30 billion rows/s., 14.27 GB/s.)
Speed up queries from any data source
ClickHouse supports all the data sources you need to power your apps and use cases that require exceptional performance.
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 OLAP databases, ClickHouse runs on every environment, whether it’s on your machine or in the cloud.
ClickHouse Local
Run fast queries on local files (CSV, TSV, Parquet, and more) without a server.
Open-source ClickHouse
Spin up a database server with open-source ClickHouse. Always Free.
ClickHouse Cloud
Deploy a fully managed ClickHouse service on AWS or GCP.
Join the 100k+ developers using ClickHouse today
1.2k+Contributors
32k+PRs
29.7k+Stars
What do developers say?
ClickHouse is the most commonly used database for internal and commercial observability platforms. Disney+ uses ClickHouse to provide analytics for its content distribution system.
“We were really not doing well with ingesting all the logs that we have because it's big data, it's all the users of Disney+ generating that data. Ever since we chose ClickHouse, it's been going well.”
Roni Lazimi
Software Engineer, Disney+
Uber’s log analytics platform
Learn why Uber migrated to ClickHouse from the ELK stack.
Cloudflare’s HTTP analytics infrastructure
Read about how Cloudflare uses ClickHouse to support 6M requests per second.
GitLab’s APM datastore
Watch this YouTube video showing why GitLab chose ClickHouse over Timescale to power their APM infrastructure.
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.
Comparisons
Stay informed on feature releases, product roadmap, support, and cloud offerings!
© 2023 ClickHouse, Inc. HQ in the Bay Area, CA and Amsterdam, NL.