We experience configuration issues when accommodating the volumes we require, which often necessitates consultation with the Cassandra development team. This aspect is room for improvement. Additionally, the initial setup was complicated and required a lot of back-and-forth questioning. The documentation could be improved to better reflect exceptional use cases.
Data Analyst at a wholesaler/distributor with 51-200 employees
Real User
Top 5
2024-04-24T19:40:08Z
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.
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.
The product is a NoSQL database. While working with it, we have to structure the table the way we want the query. We cannot get data from another table because, in Cassandra, we do not have any joins. Depending upon our schema, we can't make ORDER BY or GROUP BY clauses in the product. We should know the data we want before making the table. Only after that we can create the table. Or else we will face issues with our server, and we will have to fetch all the data and compute it in the programming language. It will become messy. It is the main drawback of the solution.
Senior System Integration Engineer at Hitachi Data Systems
Real User
Top 20
2022-12-20T14:45:22Z
Dec 20, 2022
The stability of the solution and the documentation available can be improved. The solution is limited to a linear performance, which should be improved in the next release.
Senior Database Engineer at S&P Global Market Intelligence
Real User
2022-05-18T19:39:10Z
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.
If you have a requirement of aggregation and joints, Cassandra doesn't support a solution that can give the aggregation. If they were to include these two areas, the aggregation and the complex joints, it would improve the solution a great deal.
Chief Technology Officer at a comms service provider with 1-10 employees
Real User
2022-03-09T17:04:11Z
Mar 9, 2022
The secondary index in Cassandra was a bit problematic and could be improved. Cassandra can improve by having an ecosystem integrator that was more complete. For example, in some maintenance operations, we needed to deploy external tools to perform tasks that were not packaged alongside Cassandra.
One of the issues with the solution is that you cannot drop write like you're able to in MongoDB and MySQL, where you can join tables. Cassandra doesn't have joins between tables so you need other tools for that. You need to read all the data and put in memory and then add the joins. That is the area where I think they need improvement. Secondly, for example, when setting up your cursor, you have to be very sure about the read mechanism, because if you're not following the read mechanism and mistakenly build a key that is no longer unique then you start overriding data. There are a lot of improvements they could make including on the OS.
Managing Director at a tech services company with 1-10 employees
Real User
2020-05-25T07:16:44Z
May 25, 2020
The interface could definitely be improved. It's a technical database and for me the features are not user friendly. I also think it's quite an expensive solution and I hope over time with more implementations, this will improve.
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.
We experience configuration issues when accommodating the volumes we require, which often necessitates consultation with the Cassandra development team. This aspect is room for improvement. Additionally, the initial setup was complicated and required a lot of back-and-forth questioning. The documentation could be improved to better reflect exceptional use cases.
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.
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.
The product is a NoSQL database. While working with it, we have to structure the table the way we want the query. We cannot get data from another table because, in Cassandra, we do not have any joins. Depending upon our schema, we can't make ORDER BY or GROUP BY clauses in the product. We should know the data we want before making the table. Only after that we can create the table. Or else we will face issues with our server, and we will have to fetch all the data and compute it in the programming language. It will become messy. It is the main drawback of the solution.
The stability of the solution and the documentation available can be improved. The solution is limited to a linear performance, which should be improved in the next release.
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.
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.
If you have a requirement of aggregation and joints, Cassandra doesn't support a solution that can give the aggregation. If they were to include these two areas, the aggregation and the complex joints, it would improve the solution a great deal.
The secondary index in Cassandra was a bit problematic and could be improved. Cassandra can improve by having an ecosystem integrator that was more complete. For example, in some maintenance operations, we needed to deploy external tools to perform tasks that were not packaged alongside Cassandra.
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.
One of the issues with the solution is that you cannot drop write like you're able to in MongoDB and MySQL, where you can join tables. Cassandra doesn't have joins between tables so you need other tools for that. You need to read all the data and put in memory and then add the joins. That is the area where I think they need improvement. Secondly, for example, when setting up your cursor, you have to be very sure about the read mechanism, because if you're not following the read mechanism and mistakenly build a key that is no longer unique then you start overriding data. There are a lot of improvements they could make including on the OS.
We actually find HBase to be faster and better than Cassandra. The disc space is lacking. You need to free it up as you are working.
For my use case, it was more than sufficient. I used most of the features, whatever was available. I'm not sure what else can be improved.
The interface could definitely be improved. It's a technical database and for me the features are not user friendly. I also think it's quite an expensive solution and I hope over time with more implementations, this will improve.