Cassandra vs ClickHouse comparison

Cancel
You must select at least 2 products to compare!
Apache Logo
371 views|287 comparisons
89% willing to recommend
ClickHouse Logo
151 views|140 comparisons
100% willing to recommend
Comparison Buyer's Guide
Executive Summary

We performed a comparison between Cassandra and ClickHouse based on real PeerSpot user reviews.

Find out what your peers are saying about Elastic, Meta, Chroma and others in Vector Databases.
To learn more, read our detailed Vector Databases Report (Updated: May 2024).
772,679 professionals have used our research since 2012.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"I am satisfied with the performance.""Cassandra has some features that are more useful for specific use cases where you have time series where you have huge amounts of writes. That should be quick, but not specifically the reads. We needed to have quicker reads and writes and this is why we are using Cassandra right now.""The most valuable features are the counter features and the NoSQL schema. It also has good scalability. You can scale Cassandra to any finite level.""Our primary use case for the solution is testing.""Can achieve continuous data without a single downtime because of node to node ring architecture.""The time series data was one of the best features along with auto publishing.""The most valuable features of Cassandra are the NoSQL database, high performance, and zero-copy streaming.""The most valuable feature of Cassandra is its fast retrieval. Additionally, the solution can handle large amounts of data. It is the quickest application we use."

More Cassandra Pros →

"If you have a real-time basis, you should take a look at ClickHouse because it works on a vector database, and the querying is super fast compared to traditional databases."

More ClickHouse Pros →

Cons
"Fine-tuning was a bit of a challenge.""Depending upon our schema, we can't make ORDER BY or GROUP BY clauses in the product.""The secondary index in Cassandra was a bit problematic and could be improved.""The solution is not easy to use because it is a big database and you have to learn the interface. This is the case though in most of these solutions.""The solution is limited to a linear performance.""There could be more integration, and it could be more user-friendly.""Interface is not user friendly.""It can be difficult to analyze what's going on inside of the database relative to other databases. It can also be difficult to troubleshoot sometimes."

More Cassandra Cons →

"One issue is that you need persistent volumes. Otherwise, if one system goes down, you lose data in that cluster."

More ClickHouse Cons →

Pricing and Cost Advice
  • "Cassandra is a free open source solution, but there is a commercial version available called DataStax Enterprise."
  • "There are licensing fees that must be paid, but I'm not sure if they are paid monthly or yearly."
  • "We are using the open-source version of Cassandra, the solution is free."
  • "We pay for a license."
  • "I don't have the specific numbers on pricing, but it was fairly priced."
  • More Cassandra Pricing and Cost Advice →

  • "If you have an in-house deployment on Kubernetes or something, it's going to be very cheap since you'll be managing everything."
  • More ClickHouse Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Vector Databases solutions are best for your needs.
    772,679 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:The use of Cassandra in real-time data analytics has been pivotal for our e-commerce platform. As our platform operates 24/7, providing services to sellers and customers alike, the need for real-time… more »
    Top Answer:There were challenges with the query language and the development interface. The query language, in particular, could be improved for better optimization. These challenges were encountered while using… more »
    Ask a question

    Earn 20 points

    Ranking
    12th
    out of 21 in Vector Databases
    Views
    371
    Comparisons
    287
    Reviews
    6
    Average Words per Review
    353
    Rating
    7.2
    13th
    out of 21 in Vector Databases
    Views
    151
    Comparisons
    140
    Reviews
    1
    Average Words per Review
    600
    Rating
    7.0
    Comparisons
    Couchbase logo
    Compared 22% of the time.
    MongoDB logo
    Compared 13% of the time.
    ScyllaDB logo
    Compared 12% of the time.
    InfluxDB logo
    Compared 10% of the time.
    Faiss logo
    Compared 2% of the time.
    Milvus logo
    Compared 35% of the time.
    OpenSearch logo
    Compared 34% of the time.
    PostgreSQL logo
    Compared 11% of the time.
    Learn More
    Overview

    Cassandra is a distributed and scalable database management system used for real-time data processing. 

    It is highly valued for its ability to handle large amounts of data, scalability, high availability, fault tolerance, and flexible data model. 

    It is commonly used in finance, e-commerce, and social media industries.

    ClickHouse is the fastest and most resource efficient open-source database for real-time apps and analytics.
    ClickHouse supports all the data sources you need to power your apps and use cases that require exceptional performance.
    ClickHouse uses all available system resources to their full potential to process each analytical query as fast as possible.
    ClickHouse runs on every environment, whether it’s on your machine or in the cloud.

    Sample Customers
    1. Apple 2. Netflix 3. Facebook 4. Instagram 5. Twitter 6. eBay 7. Spotify 8. Uber 9. Airbnb 10. Adobe 11. Cisco 12. IBM 13. Microsoft 14. Yahoo 15. Reddit 16. Pinterest 17. Salesforce 18. LinkedIn 19. Hulu 20. Airbnb 21. Walmart 22. Target 23. Sony 24. Intel 25. Cisco 26. HP 27. Oracle 28. SAP 29. GE 30. Siemens 31. Volkswagen 32. Toyota
    Information Not Available
    Top Industries
    REVIEWERS
    Comms Service Provider25%
    Computer Software Company13%
    University13%
    Financial Services Firm13%
    VISITORS READING REVIEWS
    Financial Services Firm20%
    Computer Software Company16%
    Comms Service Provider6%
    Healthcare Company6%
    No Data Available
    Company Size
    REVIEWERS
    Small Business39%
    Large Enterprise61%
    VISITORS READING REVIEWS
    Small Business19%
    Midsize Enterprise13%
    Large Enterprise69%
    No Data Available
    Buyer's Guide
    Vector Databases
    May 2024
    Find out what your peers are saying about Elastic, Meta, Chroma and others in Vector Databases. Updated: May 2024.
    772,679 professionals have used our research since 2012.

    Cassandra is ranked 12th in Vector Databases with 19 reviews while ClickHouse is ranked 13th in Vector Databases with 1 review. Cassandra is rated 8.0, while ClickHouse is rated 7.0. The top reviewer of Cassandra writes "Well-equipped to handle a massive influx of data and billions of requests". On the other hand, the top reviewer of ClickHouse writes "Query engine is super fast but improvement needed in integration to third-party applications or the cloud". Cassandra is most compared with Couchbase, MongoDB, ScyllaDB, InfluxDB and Faiss, whereas ClickHouse is most compared with Milvus, OpenSearch and PostgreSQL.

    See our list of best Vector Databases vendors.

    We monitor all Vector Databases reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.