Introduction to Cassandra Query Language

Cassandra Query Language (CQL) is a query language for the Cassandra database.

About this document

Welcome to the CQL documentation provided by DataStax. To ensure that you get the best experience in using this document, take a moment to look at the Tips for using DataStax documentation.

Overview of the Cassandra Query Language

Cassandra Query Language (CQL) is a query language for the Cassandra database. This release of CQL works with Cassandra 3.0.

The Cassandra Query Language (CQL) is the primary language for communicating with the Cassandra database. The most basic way to interact with Cassandra is using the CQL shell, cqlsh. Using cqlsh, you can create keyspaces and tables, insert and query tables, plus much more. If you prefer a graphical tool, you can use DataStax DevCenter. For production, DataStax supplies a number of drivers so that CQL statements can be passed from client to cluster and back.

Important: This document assumes you are familiar with the Cassandra 3.0 documentation.

Table 1. CQL for Cassandra 3.0 features
New CQL features	JSON support for CQL3 User Defined Functions (UDFs) User Defined Aggregates (UDAs) Role Based Access Control (RBAC) Native Protocol v.4 Materialized Views Addition of CLEAR command for cqlsh
Improved CQL features	Additional COPY command options New WITH ID option with `CREATE TABLE` command Support IN clause on any partition key column or clustering column Accept Dollar Quoted Strings Allow Mixing Token and Partition Key Restrictions Support Indexing Key/Value Entries on Map Collections Date data type added and improved time/date conversion functions Tinyint and smallint data types added Change to CREATE TABLE syntax for compression options
Removed CQL features	Removal of CQL2 Removal of cassandra-cli
Native protocol	The Native Protocol has been updated to version 4, with implications for CQL use in the DataStax drivers.