In our latest benchmark report, we find ClickHouse is six times faster than Druid and four times faster than Rockset while using a cheaper AWS setup.

Rick Bilodeau from Imply published an excellent article in June 2020 comparing Druid cost-efficiency to Google Big Query for what they called ‘hot analytics’ — sub-second response time with high query concurrency. We appreciate this effort and the great results of open-source technology. In that article, Rick used the popular Star Schema Benchmark (SSB).

We know this benchmark very well. One of Altinity founders and Percona CTO Vadim Tkachenko uses it quite regularly when comparing different open source analytical options (in 2017 and in 2020). A few weeks ago another real-time analytics company Rockset published their results claiming much better performance and efficiency compared to Druid. We decided to take a closer look at the Druid and Rockset approach, and see how ClickHouse can perform.

To make a long story short, we were pleased to confirm that ClickHouse is 6 times faster than Druid and 4 times faster than Rockset with fewer hardware resources!

#database performance #benchmark #real time analytics #clickhouse #druid #analytical databases #performance benchmark