When should you not use Cassandra? OR When to use RDBMS instead of Cassandra?
Cassandra is based on the NoSQL database and does not provide ACID and relational data property. If you have a strong requirement of ACID property (for example Financial data), Cassandra would not be a fit in that case. Obviously, you can make work out of it, however, you will end up writing lots of application code to handle ACID property and will loose on time to market badly. Also managing that kind of system with Cassandra would be complex and tedious for you.
