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."
Co-founder and CTO, Vantage
"There is that feeling of new tech where everything just feels like it's going right."
Co-founder and CTO, Clearbit
"We wanted something not only just simple to use, but also simple to manage."
Software Engineer, Statsig