Cassandra is officially a NoSQL database, however it pretty much acts as SQL database from administration point of view :) You can use SQLs such as Selects, Updates, deleted, etc. You can create tables and other object related operations:
Cassandra Clusters extends the HA features.