olapclickhouseolap-cubedruid

how to apache druid or clickhouse


I‘m a new to clickhouse, and already read "druid vs clickhouse", but still don't know which situation can use clickhouse. I know they are good OLAP engines。

Druid is an excellent timing database。 At large data scale, it can provide ad-hoc aggregate queries,clickhouse too;

They have similar disadvantages, such as slow data writing。

Which engine should I do with OLAP?


Solution

  • This is the great article https://leventov.medium.com/comparison-of-the-open-source-olap-systems-for-big-data-clickhouse-druid-and-pinot-8e042a5ed1c7

    Either your organization should have engineers who are able to read, understand and modify the source code of the chosen system, and have capacity to do that. Note that ClickHouse is written in C++, Druid and Pinot — in Java.