Due to the complex data structures that Cassandra has to offer, there is a very applicable need for a simple way to manipulate the data you have stored. SQL seemed to be the obvious choice, but there are many things that SQL offers in the way of RDBMSs that Cassandra just cannot yet do.
Enter CQL. Cassandra Query Language (CQL) strives to be as close to SQL as possible. Given that Cassandra is a non-relational database, a fully featured SQL construct is not possible. The main thing to note about CQL is that it has no concept of GROUP or JOIN, and a very limited implementation of ORDER BY.
This chapter will focus on data creation and manipulation using CQL3. We will show the parallels of CQL with other features of Cassandra and show the ...