TrustRadius: an HG Insights company

ClickHouse Reviews & Insights

Score6.7 out of 10

9 Reviews and Ratings

Get a Demo

Community insights

TrustRadius Insights for ClickHouse are summaries of user sentiment data from TrustRadius reviews and, when necessary, third party data sources.

Pros

Fast Query Performance: Reviewers have praised ClickHouse for its fast query performance when retrieving large amounts of data. Multiple users have stated that the software's column-oriented structure and use of vectors and merging algorithms make it a powerful tool for performing operations quickly and efficiently.

Easy to Use: Several reviewers have found ClickHouse to be an easy-to-use database management system due to its SQL-like syntax, flexible choice of engines, fault-tolerance, and multi-master architecture. Users have also appreciated the simple installation process and the software's rich functions for analytics on big datasets.

Great Functionality: Many users have praised ClickHouse's functionality in managing databases, giving very fast write and query performance compared to RDBMS. The software's compression algorithm is a standout feature, making it easier to dump and retrieve data from the database. Additionally, reviewers appreciate the broad coverage of tests, searching and partitioning, replications, as well as the availability of engines for almost all use cases.

ClickHouse Reviews

2 Reviews

Ridiculous fast for analytical workloads

Rating: 10 out of 10
Incentivized

Use Cases and Deployment Scope

ClickHouse serves as our primary Data Warehouse, empowering both our BI Solutions and in-house data products with real-time insights. It enables us to quickly derive actionable insights and respond to live data, meeting the demand for instantaneous decision-making. With its broad scope, ClickHouse consolidates diverse data sources, serving as our central and unified repository.

Pros

  • Their MergeTree table engine provide impressive performance for data insert in bulk
  • Not only data insert but also the way MergeTree engine uses Primary Keys to sort the data and perform data skipping based on the granules its also their secret for ridiculous fast queries
  • Data compression its also great
  • They provide especial table engines that allow you to read data directly from other sources like S3
  • Since its written with C++ you have very granular data types and especial ones like enum, LowCardinality and etc, they save you a lot of storage since are stored as integer values
  • ClickHouse functions besides the ones that respect ANSI Standards are also awesome and useful

Cons

  • SQL Console is their solution to run queries through a Web UI, still misses some extra functionally like visually seeing the query plan and more info about the query that is running, would be useful
  • Managing roles in the Cloud could have more options, not only admin/developer, something like Guest, because the developer get by default read access to everything, and I would prefer having to manually provide access to the guest users
  • It stills misses SSO compatibility with some Identity Providers like Okta, especially for just DB Users

Likelihood to Recommend

ClickHouse delivers exceptional speed and performance, positioning it as the top choice for managing large-scale analytical workloads. With a bunch of built-in functions, it empowers analysts to extract maximum insights from data effortlessly.

If your scenario is to deal with analytical questions, then ClickHouse is for you, but if you are looking into a transactional database, that's not the case; even their table engines are not made for this.
VU
Verified User
Engineer in Engineering (201-500 employees)
Vetted Review
ClickHouse
2 years of experience

The best analytic database to add your analitical system

Rating: 9 out of 10
Incentivized

Use Cases and Deployment Scope

ClickHouse is used to carry out analysis tasks that traditional databases are not capable of performing, either because they are too expensive or because the volume of data is so large that it is not feasible to analyze it with queries comfortably. The analysis of indicators on which aggregations are needed but not on the rest of the indicators that are stored together in the same traditional table is one of the biggest problems that ClickHouse solves, making the queries run very fast with hardware that is not as advanced as it would be for a traditional table.

Pros

  • Opensource
  • High performance
  • Multiple engines to adapt user cases
  • Easy configuration of data replication

Cons

  • Avro data manipulation
  • Kafka consistency
  • DDL operations errors (by replica configuration)

Likelihood to Recommend

The most important thing when using ClickHouse is to be clear that the scenarios in which you want to use it really are the right ones. Many users think that when a database is very fast for a specific use case, it can be extrapolated to other contexts (most of the time different) in which a previous analysis has not been carried out.

ClickHouse is an analytical database, as such, it should be used for such purposes, where the information is stored correctly, the data volumes are really large and the queries to be performed are not the typical traditional queries on several columns with multiple aggregations. ClickHouse is not the solution for this.

On the other hand, if your case is not one of the above, it is quite possible that ClickHouse can help you. Where ClickHouse shines is when you are looking for aggregation over a particular column in large volumes of data.
VU
Verified User
Engineer in Information Technology (1001-5000 employees)
Vetted Review
ClickHouse
1 year of experience