4 ms·

How does clickhouse compare to druid, pinot, rockset (commercial), memsql (commercial). I know clickhouse is easier to deploy. But from user's perspective is

How does clickhouse compare to druid, pinot, rockset (commercial), memsql (commercial). I know clickhouse is easier to deploy. But from user's perspective is clickhouse superior to the others?

jetter 6y ago
I've mentioned Pinot and Druid briefly in 2018 writeup: https://pixeljets.com/blog/clickhouse-as-a-replacement-for-elk-big-query-and-timescaledb/ https://pixeljets.com/blog/clickhouse-as-a-replacement-for-e... (see "Compete with Pinot and Druid" )
caust1c 6y ago
When Cloudflare was considering clickhouse, we did estimates on just the hardware cost and it was well over 10x what clickhouse was based on druids given numbers on events processed per compute unit.
- advaita 6y ago
  Are you saying druid hardware costs were coming out to be 10x of clickhouse hardware costs? Caveat: English is not my first language so might have missed your point in translation. :)
  - caust1c 6y ago
    That's right, yeah. We would have had to buy 10x the servers in order to support the same workload that clickhouse could.
AurimasJLT 6y ago
Yeah Druid got blown away by ClickHouse at eBay Druid 700+ servers versus 2 region fully replicated ClickHouse system of 40 nodes. https://tech.ebayinc.com/engineering/ou-online-analytical-processing/ https://tech.ebayinc.com/engineering/ou-online-analytical-pr... and a webinar they did with us at Altinity https://www.youtube.com/watch?v=KI0AqpmcSOk&t=20s https://www.youtube.com/watch?v=KI0AqpmcSOk&t=20s
mgachka 6y ago
FYI, we're using clickhouse since 2018 at ContentSquare. I did a few POCs to compare clickhouse vs other databases on ContentSquare's use case. One of them was memSQL. Although memSQL was very good, since we don't need to JOIN big datasets or need killer features like fulltext search, clickhouse gave a better perf/cost ratio for us (I don't remember exactly but it was at least twice cheaper).

How does clickhouse compare to druid, pinot, rockset (commercial), memsql (commercial). I know clickhouse is easier to deploy. But from user's perspective is clickhouse superior to the others?

jetter 6y ago

I've mentioned Pinot and Druid briefly in 2018 writeup: https://pixeljets.com/blog/clickhouse-as-a-replacement-for-elk-big-query-and-timescaledb/ https://pixeljets.com/blog/clickhouse-as-a-replacement-for-e... (see "Compete with Pinot and Druid" )

caust1c 6y ago

When Cloudflare was considering clickhouse, we did estimates on just the hardware cost and it was well over 10x what clickhouse was based on druids given numbers on events processed per compute unit.

advaita 6y ago
Are you saying druid hardware costs were coming out to be 10x of clickhouse hardware costs? Caveat: English is not my first language so might have missed your point in translation. :)
- caust1c 6y ago
  That's right, yeah. We would have had to buy 10x the servers in order to support the same workload that clickhouse could.

AurimasJLT 6y ago

Yeah Druid got blown away by ClickHouse at eBay Druid 700+ servers versus 2 region fully replicated ClickHouse system of 40 nodes. https://tech.ebayinc.com/engineering/ou-online-analytical-processing/ https://tech.ebayinc.com/engineering/ou-online-analytical-pr... and a webinar they did with us at Altinity https://www.youtube.com/watch?v=KI0AqpmcSOk&t=20s https://www.youtube.com/watch?v=KI0AqpmcSOk&t=20s

mgachka 6y ago

FYI, we're using clickhouse since 2018 at ContentSquare. I did a few POCs to compare clickhouse vs other databases on ContentSquare's use case. One of them was memSQL. Although memSQL was very good, since we don't need to JOIN big datasets or need killer features like fulltext search, clickhouse gave a better perf/cost ratio for us (I don't remember exactly but it was at least twice cheaper).