TrustRadius

ClickHouse vs. Rockset

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
ClickHouse
Score 6.6 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
Rockset
Score 1.2 out of 10
N/A
Rockset is a serverless search and analytics engine that does fast SQL on NoSQL data from Kafka, DynamoDB, S3 and more. According to the vendor, it delivers millisecond-latency SQL over TBs of raw data, without any ETL. Rockset integrates with the user's database, data stream or data lake to continuously ingest new data without requiring a schema, while providing full SQL support for filtering, aggregations and joining streaming data with other data sets. Rockset powers data-driven applications…N/A
Pricing
ClickHouseRockset
Editions & Modules
No answers on this topic
No answers on this topic
Offerings
Pricing Offerings
ClickHouseRockset
Free Trial
YesNo
Free/Freemium Version
YesNo
Premium Consulting/Integration Services
NoNo
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
ClickHouseRockset
Considered Both Products
ClickHouse
Verified User
Anonymous
Chose ClickHouse
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.
Verified User
Anonymous
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 …
Rockset
Best Alternatives
ClickHouseRockset
Small Businesses
InterSystems IRIS
InterSystems IRIS
Score 8.1 out of 10
Yext
Yext
Score 7.5 out of 10
Medium-sized Companies
InterSystems IRIS
InterSystems IRIS
Score 8.1 out of 10
Guru
Guru
Score 9.3 out of 10
Enterprises
SAP IQ
SAP IQ
Score 6.0 out of 10
Guru
Guru
Score 9.3 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
ClickHouseRockset
Likelihood to Recommend
10.0
(0 ratings)
9.0
(0 ratings)
User Testimonials
ClickHouseRockset
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.
Verified User
Anonymous
Read full review
1. Usage based billing - helpful in creating query lambdas and workflow around them. 2. Fast data refresh and scheduled running of queries is required. 3. Wherever real-time data is in play in terms of visibility.
Verified User
Anonymous
Read full review
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
Verified User
Anonymous
Read full review
  • Fast ingest and real-time indexing
  • Complex SQL queries run really fast
  • Lower cost in terms of deployment.
Verified User
Anonymous
Read full review
Cons
  • Avro data manipulation
  • Kafka consistency
  • DDL operations errors (by replica configuration)
Verified User
Anonymous
Read full review
  • User interface
  • AI in queries, auto-generated queries
  • Graphing tools
Verified User
Anonymous
Read full review
Alternatives Considered
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.
Verified User
Anonymous
Read full review
No answers on this topic
Return on Investment
  • 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
Verified User
Anonymous
Read full review
  • Didn't need to invest in an external billing software.
  • Major customer feature ask was fulfilled - realtime usage overview
Verified User
Anonymous
Read full review
ScreenShots