Need advice about which tool to choose?Ask the StackShare community!
Clickhouse vs Druid: What are the differences?
Clickhouse: A column-oriented database management system. It allows analysis of data that is updated in real time. It offers instant results in most cases: the data is processed faster than it takes to create a query; Druid: Fast column-oriented distributed data store. Druid is a distributed, column-oriented, real-time analytics data store that is commonly used to power exploratory dashboards in multi-tenant environments. Druid excels as a data warehousing solution for fast aggregate queries on petabyte sized data sets. Druid supports a variety of flexible filters, exact calculations, approximate algorithms, and other useful calculations.
Clickhouse can be classified as a tool in the "Databases" category, while Druid is grouped under "Big Data Tools".
Druid is an open source tool with 8.32K GitHub stars and 2.08K GitHub forks. Here's a link to Druid's open source repository on GitHub.
Pros of Clickhouse
- Fast, very very fast19
- Good compression ratio11
- Horizontally scalable6
- Great CLI5
- RESTful5
- Utilizes all CPU resources5
- Open-source4
- Great number of SQL functions4
- Has no transactions3
- Buggy3
- Server crashes its normal :(2
- ODBC2
- Flexible connection options2
- Flexible compression options2
- Highly available2
- In IDEA data import via HTTP interface not working1
Pros of Druid
- Real Time Aggregations15
- Batch and Real-Time Ingestion6
- OLAP4
- OLAP + OLTP3
- Combining stream and historical analytics2
- OLTP1
Sign up to add or upvote prosMake informed product decisions
Cons of Clickhouse
- Slow insert operations5
Cons of Druid
- Limited sql support3
- Joins are not supported well2
- Complexity1