TrustRadius: an HG Insights company

Save this comparison

Save this comparison

Add Product

Recommended Comparisons

    Overview
    ProductRatingMost Used ByProduct SummaryStarting Price

    ClickHouse

    Score7 out of 10
    N/AClickHouse 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

    Cloudera Data Platform

    Score6.5 out of 10
    N/ACloudera Data Platform (CDP), launched September 2019, is designed to combine the best of Hortonworks and Cloudera technologies to deliver an enterprise data cloud. CDP includes the Cloudera Data Warehouse and machine learning services as well as a Data Hub service for building custom business applications.

    $0.04

    per CCU (hourly rate)

    Pricing
    ClickHouseCloudera Data Platform
    Editions & Modules
    No answers on this topic
    CDP Public Cloud - Data Hub
    $0.04
    per CCU (hourly rate)
    CDP Public Cloud - Data Warehouse
    $0.054
    per CCU (hourly rate)
    CDP Public Cloud - Data Engineering
    $0.07
    per CCU (hourly rate)
    CDP Public Cloud - Operational Database
    $0.08
    per CCU (hourly rate)
    CDP Public Cloud - Flow Management
    $0.15
    per CCU (hourly rate)
    CDP Public Cloud - Machine Learning
    $0.17
    per CCU (hourly rate)
    CDP Private Cloud - Plus Edition
    $400
    CCU (annual subscription)
    CDP Private Cloud - Base Edition
    $10,000.00
    node + variable (annual subscription)
    Offerings
    Pricing Offerings
    ClickHouseCloudera Data Platform
    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
    Best Alternatives
    ClickHouseCloudera Data Platform
    Small Businesses
    SingleStore
    Score7.5 out of 10
    No answers on this topic
    Medium-sized Companies
    SAP HANA Cloud
    Score8.9 out of 10
    Cloudera Enterprise Data Hub
    Score9 out of 10
    Enterprises
    SAP IQ
    Score10 out of 10
    Oracle Exadata
    Score10 out of 10
    All AlternativesView all alternativesView all alternatives
    User Ratings
    ClickHouseCloudera Data Platform
    Likelihood to Recommend
    10.0
    (2 ratings)
    7.0
    (1 ratings)
    Support Rating
    -
    (0 ratings)
    8.0
    (1 ratings)
    User Testimonials
    ClickHouseCloudera Data Platform
    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.
    Incentivized
    Read full review
    Cloudera
    I have seen that Cloudera Data Platform is well suited for large batch processes. It works really well for our indication analyses that are performed by the actuaries. I feel that rapid streaming operations may be a situation where additional technology would be needed to provide for a robust solution.
    Incentivized
    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
    Incentivized
    Read full review
    Cloudera
    • Scales
    • Highly available
    Incentivized
    Read full review
    Cons
    ClickHouse, Inc.
    • Avro data manipulation
    • Kafka consistency
    • DDL operations errors (by replica configuration)
    Incentivized
    Read full review
    Cloudera
    • Constantly changing costs
    • Log visibility
    Incentivized
    Read full review
    Support Rating
    ClickHouse, Inc.
    No answers on this topic
    Cloudera
    We have utilized Cloudera support quite frequently and are very satisfied with the capability and responsiveness of that team. Often, the new features delivered with the platform give us an opportunity to mature the way we're doing things, and the support team have been valuable in developing those new patterns.
    Incentivized
    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.
    Incentivized
    Read full review
    Cloudera
    IBM's offering of the Cloud Pak for Data has been a moving target and difficult to compare to Cloudera Data Platform. We have implemented our solution on Amazon Web Services, which appears to be supported by IBM at this point, but the migration would be very expensive for us to endeavor.
    Incentivized
    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
    Incentivized
    Read full review
    Cloudera
    • Reduced operational costs
    • Speed to market
    Incentivized
    Read full review
    ScreenShots