Try our new research platform with insights from 80,000+ expert users
Cassandra Logo

Cassandra pros and cons

Vendor: Apache
4.0 out of 5
590 followers
Post review

Pros & Cons summary

Buyer's Guide

Get pricing advice, tips, use cases and valuable features from real users of this product.
Get the report

Prominent pros & cons

PROS

Cassandra achieves continuous data availability through its node-to-node ring architecture, ensuring zero downtime.
It offers superior performance compared to relational databases with its high scalability and distributed nature.
Key features include NoSQL schema, counter functionality, and strong time series data capabilities.
It excels in fast data retrieval, making it suitable for real-time analytics and handling large data volumes.
Cassandra's distribution allows for a seamless cloud and on-premise setup, providing flexibility and reliability.

CONS

Cassandra can improve performance issues related to data fetching from large datasets and batch inserts.
Cassandra lacks built-in tools for maintenance activities, necessitating reliance on third-party tools.
Cassandra does not support joins between tables, requiring other tools for such operations.
Cassandra's initial setup and configuration can be complex, potentially requiring external assistance.
Cassandra has limitations in handling queries, including restrictions with ORDER BY and GROUP BY clauses.
 

Cassandra Pros review quotes

NA
Nov 12, 2020
The time series data was one of the best features along with auto publishing.
Himanshu Amodwala - PeerSpot reviewer
Feb 26, 2024
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 updates is paramount.
RT
Jan 24, 2025
Its retrieval is similar to an RDBMS, so our team finds it easy to adapt.
Learn what your peers think about Cassandra. Get advice and tips from experienced pros sharing their opinions. Updated: February 2025.
838,713 professionals have used our research since 2012.
reviewer2379771 - PeerSpot reviewer
Apr 24, 2024
Since I haven't had years of experience with it, it's still new to me. One valuable feature is its distribution, so I can run it partly in the cloud and part on-prem. That's a feature I'd like to use but haven't yet because we're trying to move to Azure. I don't know if or when that will happen. Ideally, we'd have it distributed over the cloud and on-prem simultaneously, so if something happens to our on-prem, we can keep going in the cloud, like a pay-as-you-go model with Azure.
SS
Nov 10, 2020
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.
Phillip Peter - PeerSpot reviewer
Mar 25, 2022
I am satisfied with the performance.
Chethan Rao S - PeerSpot reviewer
Jun 23, 2023
We can add almost one million columns to the solution.
MA
Nov 6, 2024
The most valuable features of Cassandra are its scaling capabilities and its non-SQL nature capabilities.
reviewer1419942 - PeerSpot reviewer
May 18, 2022
The most valuable features of Cassandra are the NoSQL database, high performance, and zero-copy streaming.
reviewer1531995 - PeerSpot reviewer
May 18, 2021
Some of the valued features of this solution are it has good performance and failover.
 

Cassandra Cons review quotes

NA
Nov 12, 2020
The solution doesn't have joins between tables so you need other tools for that.
Himanshu Amodwala - PeerSpot reviewer
Feb 26, 2024
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 the Java SDK.
RT
Jan 24, 2025
We found some issues with the batch inserts when the data volume is large.
Learn what your peers think about Cassandra. Get advice and tips from experienced pros sharing their opinions. Updated: February 2025.
838,713 professionals have used our research since 2012.
reviewer2379771 - PeerSpot reviewer
Apr 24, 2024
I want Cassandra to update its open-source version more quickly. It's already feature-rich, but I'd appreciate better integration with other NoSQL databases like MariaDB or MongoDB. If I ever need to work with customers or vendors using different NoSQL databases, having native integration in Cassandra would make managing and interacting with their databases much easier.
SS
Nov 10, 2020
Fine-tuning was a bit of a challenge.
Phillip Peter - PeerSpot reviewer
Mar 25, 2022
There could be more integration, and it could be more user-friendly.
Chethan Rao S - PeerSpot reviewer
Jun 23, 2023
Depending upon our schema, we can't make ORDER BY or GROUP BY clauses in the product.
MA
Nov 6, 2024
We experience configuration issues when accommodating the volumes we require, which often necessitates consultation with the Cassandra development team.
reviewer1419942 - PeerSpot reviewer
May 18, 2022
Cassandra can improve by adding more built-in tools. For example, if you want to do some maintenance activities in the cluster, we have to depend on third-party tools. Having these tools build-in would be e benefit.
reviewer1531995 - PeerSpot reviewer
May 18, 2021
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.