The best analytic database to add your analitical system
August 02, 2021

The best analytic database to add your analitical system

Anonymous | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User

Overall Satisfaction with ClickHouse

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)
  • Open source
  • High performance
  • Escalability
  • Multiples engines
  • Queries that used to take more than 2 minutes now take less than 1 second
  • Possibility to analyze use cases in real time (before was impossible)
  • The applications are more complete and the users decisions are better
ClickHouse was not compared to them as a competitor but as the ideal partner to complete an information analysis system, providing users with the most complete and efficient tools. Therefore, in this case it was considered that it would be the ideal candidate due to its characteristics compared to the other competitors.

Do you think ClickHouse delivers good value for the price?

Yes

Are you happy with ClickHouse's feature set?

Yes

Did ClickHouse live up to sales and marketing promises?

I wasn't involved with the selection/purchase process

Did implementation of ClickHouse go as expected?

Yes

Would you buy ClickHouse again?

Yes

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.

Comments

More Reviews of ClickHouse

  1. Home
  2. Relational Databases
  3. ClickHouse Reviews
  4. User Review of ClickHouse