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.)
"Moving over to ClickHouse we were basically able to cut that (Redshift) bill in half."
Brooke McKim
Co-founder and CTO, Vantage
"There is that feeling of new tech where everything just feels like it's going right."
Harlow Ward
Co-founder and CTO, Clearbit
"We wanted something not only just simple to use, but also simple to manage."
Jason Wang
Software Engineer, Statsig
"ClickHouse has been great for us. It has solved all the use cases we have thrown at it"
Ritesh Varyani
Senior Software Engineer, Lyft
Speed up queries from any data source
Why is ClickHouse so fast?
Deploy your way
What do developers say?
FAQs
Start using ClickHouse in minutes
curl https://clickhouse.com/ | sh
Watch this getting started video to learn more about ClickHouse.