O'Reilly logo

Practical Cassandra: A Developer’s Approach by Eric Lubow, Russell Bradberry

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

4. CQL

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required