Ranked in these QuestionsQuestion Ranking
Pro Highly scalable
Cassandra is very scalable and achieves the highest throughput for the maximum number of nodes compared to other alternatives. Unfortunately this also brings rather high write and read latencies.
Pro Familiar to developers used to SQL
The query language that Cassandra uses (CQL) is similar to SQL even though it's a NoSQL database.
Con Not for newbies
If your dataset is in order of gigabytes then maybe consider a toy database, not a serious one like Cassandra.
Con No JOINS
Cassandra has no support for JOINS.