NoSQL: What is a Cassandra Query Language (CQL)?

NoSQL Cassandra CQL
The Cassandra Query Language (CQL) is the main language for working with Cassandra Database.
You can easily interact with Cassandra using the CQL shell (cqlsh).

The latest version of Cassandra Query Language is v3.3.1. (as per April – 2016).
You can visit full help of CQL at the official link of Apache Cassandra(CQL).

For the RDBMS people, it is very easy to learn and migrate in Cassandra because most of the syntax of CQL is very similar to RDBMS SQL.
You can also use DataStax DevCenter for graphical tool.

Using CQL, you can perform all different DML and DDL statements, you can also create User Defined Functions, Types, Roles, Triggers, Aggregate Functions and many more.
It is also useful in knowing the information related to clusters, Keyspace structure and other meta information.

There are also some limitations of CQL.
CQL doesn’t support aggregation like max, min, ava, group by and having.
CQL doesn’t support Joins and Wildcard queries.
CQL doesn’t support Union and Intersection.

Please share your ideas and opinions about this topic with me, your contribution will add true value to this topic.
If anyone has doubts on this topic then please do let me know by leaving comments or send me an email.

If you like this post, then please share it with others.
Please follow, I will share my experience towards the success of Database Research and Development Activity.

I put up a post every day, please keep reading and learning.
Discover Yourself, Happy Blogging !
Anvesh M. Patel.

More from

Leave a Reply

Be the First to Comment!

Notify of