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
Sign up to add or upvote consMake informed product decisions
What is Clickhouse?
What is Druid?
Need advice about which tool to choose?Ask the StackShare community!
What companies use Clickhouse?
What companies use Druid?
Sign up to get full access to all the companiesMake informed product decisions
What tools integrate with Clickhouse?
Sign up to get full access to all the tool integrationsMake informed product decisions
Blog Posts
+3
+4
+6
+12