ClickHouse

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
ClickHouse
Score 9.8 out of 10
N/A
ClickHouse is an open-source, column-oriented OLAP database system enabling real-time analytical reports using SQL queries. With linear scalability, it handles trillions of rows and petabytes of data. ClickHouse Cloud offers a scalable serverless solution for real-time analytics.N/A
Pricing
ClickHouse
Editions & Modules
No answers on this topic
Offerings
Pricing Offerings
ClickHouse
Free Trial
Yes
Free/Freemium Version
Yes
Premium Consulting/Integration Services
Yes
Entry-level Setup FeeOptional
Additional DetailsPay for what is used: It automatically scales up and down compute resources based on the user's workload It scales storage and compute separately It automatically scales unused resources down to zero so that users don’t pay for idle services
More Pricing Information
Community Pulse
ClickHouse
Considered Both Products
ClickHouse
Chose ClickHouse
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 …
Top Pros
Top Cons
Best Alternatives
ClickHouse
Small Businesses
SingleStore
SingleStore
Score 9.8 out of 10
Medium-sized Companies
SingleStore
SingleStore
Score 9.8 out of 10
Enterprises
SingleStore
SingleStore
Score 9.8 out of 10
All AlternativesView all alternatives
User Ratings
ClickHouse
Likelihood to Recommend
9.0
(1 ratings)
User Testimonials
ClickHouse
Likelihood to Recommend
ClickHouse, Inc.
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.
Read full review
Pros
ClickHouse, Inc.
  • Opensource
  • High performance
  • Multiple engines to adapt user cases
  • Easy configuration of data replication
Read full review
Cons
ClickHouse, Inc.
  • Avro data manipulation
  • Kafka consistency
  • DDL operations errors (by replica configuration)
Read full review
Alternatives Considered
ClickHouse, Inc.
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.
Read full review
Return on Investment
ClickHouse, Inc.
  • 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
Read full review
ScreenShots