ClickHouse vs. Exasol

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
ClickHouse
Score 7.0 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
Exasol
Score 8.6 out of 10
N/A
Exasol, from the company of the same name in Nuremberg, is presented by the vendor as a high-performance in-memory analytics database that aims to transform how organizations works with data, on-premises, in the cloud or both.N/A
Pricing
ClickHouseExasol
Editions & Modules
No answers on this topic
No answers on this topic
Offerings
Pricing Offerings
ClickHouseExasol
Free Trial
YesNo
Free/Freemium Version
YesNo
Premium Consulting/Integration Services
YesNo
Entry-level Setup FeeOptionalNo setup fee
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
ClickHouseExasol
Features
ClickHouseExasol
Relational Databases
Comparison of Relational Databases features of Product A and Product B
ClickHouse
-
Ratings
Exasol
8.6
1 Ratings
8% above category average
ACID compliance00 Ratings8.01 Ratings
Database monitoring00 Ratings8.01 Ratings
Database locking00 Ratings9.01 Ratings
Encryption00 Ratings9.01 Ratings
Disaster recovery00 Ratings9.01 Ratings
Flexible deployment00 Ratings8.01 Ratings
Multiple datatypes00 Ratings9.01 Ratings
Best Alternatives
ClickHouseExasol
Small Businesses
InterSystems IRIS
InterSystems IRIS
Score 8.0 out of 10
InterSystems IRIS
InterSystems IRIS
Score 8.0 out of 10
Medium-sized Companies
InterSystems IRIS
InterSystems IRIS
Score 8.0 out of 10
InterSystems IRIS
InterSystems IRIS
Score 8.0 out of 10
Enterprises
SAP IQ
SAP IQ
Score 10.0 out of 10
SAP IQ
SAP IQ
Score 10.0 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
ClickHouseExasol
Likelihood to Recommend
10.0
(2 ratings)
9.0
(3 ratings)
Usability
-
(0 ratings)
8.6
(3 ratings)
Support Rating
-
(0 ratings)
9.1
(1 ratings)
User Testimonials
ClickHouseExasol
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
Exasol
Exasol is suited to applications requiring fewer & larger queries (reporting/data analytics/business intelligence tools). Its per-query overhead makes it unsuitable as an operational database (those are optimized for many & smaller queries.)
Read full review
Pros
ClickHouse, Inc.
  • 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
Read full review
Exasol
  • Performance in ELT/ETL transformations
  • Analytical queries for ad-hoc reporting
  • Python and java code directly in the database near the data!
Read full review
Cons
ClickHouse, Inc.
  • Avro data manipulation
  • Kafka consistency
  • DDL operations errors (by replica configuration)
Read full review
Exasol
  • SaaS offering in Azure
  • Upgradability
  • Management interface
Read full review
Usability
ClickHouse, Inc.
No answers on this topic
Exasol
Easy to use foundation, fast and reliable
Read full review
Support Rating
ClickHouse, Inc.
No answers on this topic
Exasol
I have had only positive experiences with their support. They are fast, knowledgeable, and courteous. Online support requests get picked up within hours. I've only once had to use their hotline and that was for an emergency. There was even one minor non-security bug report that I reported and which they fixed in the following week's minor release. I was quite impressed.
Read full review
Alternatives Considered
ClickHouse, Inc.
ClickHouse outperforms, especially in costs, since its compression/indexing engines are so smart, and even with very low computing power, you can already perform huge analyses of the data.
Read full review
Exasol
Exasol have the best performance by far in analytical queries (DW/BI). Compared to the other database we use much less time on maintenance, actually almost 0 time on indexes distributing data on nodes etc. The system just works out-of-box as long as you have memory enough
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
Exasol
  • Reduced support needs
  • Monetisation
  • Huge performance benfits
Read full review
ScreenShots