MariaDB Cassandra Storage Engine aim is integration of SQL and NoSQL worlds.
It makes it possible to :
- access Cassandra’s data from a MySQL SQL query
- insert data into Cassandra through SQL
Cassandra’s column families are seen as tables in MariaDB. You can insert, update, and select on these MariaDB Cassandra tables. Joins are possible even with data that is not stored in Cassandra( for example innoDB).
This SQL access nicely complement the Cassandra Query Language (CQL). CQL looks like SQL but is much more limited(no joins). The MariaDB Cassandra storage Engine allows to build architectures mixing SQL and NoSQL.