Have a question or want live help from a DataStax engineer? Let's chat.

Jump to main content

Support
DataStax Home
Downloads

Learn
Drivers
Glossary
Get Live Help

Introduction to Cassandra Query Language
CQL data modeling
Using CQL
CQL reference

Can't find what you're looking for? Try searching other guides

CQL for Apache Cassandra™ 2.2 and 3.x

Introduction to Cassandra Query Language
Cassandra Query Language (CQL) is a query language for the Cassandra database.
CQL data modeling
Data modeling topics.
Using CQL
CQL provides an API to Cassandra that is simpler than the Thrift API.
CQL reference
CQL reference topics.
- Introduction
  About using CQL.
- CQL lexical structure
  CQL input consists of statements that change data, look up data, store data, or change the way data is stored.
- CQL data types
  Built-in data types for columns.
- Functions
  CQL support functions for transforming one or more column values into a new value.
- CQL limits
  Upper CQL limits.
- CQL shell commands
  The CQL shell (cqlsh utility) commands.
- CQL commands
  CQL commands.
  - ALTER KEYSPACE
    Changes keyspace replication and enable/disable commit log.
  - ALTER MATERIALIZED VIEW
    Changes the table properties of a materialized view, Cassandra 3.0 and later.
  - ALTER ROLE
    Changes password, and set superuser or login options.
  - ALTER TABLE
    Modifies the columns and properties of a table.
  - ALTER TYPE
    Modify a user-defined type. Cassandra 2.1 and later.
  - ALTER USER
    Alter existing user options.
  - BATCH
    Applies multiple data modification language (DML) statements with atomicity and/or in isolation.
  - CREATE AGGREGATE
    Create user-defined aggregate.
  - CREATE CUSTOM INDEX (SASI)
    Generates a SASI index on a single table column.
  - CREATE INDEX
    Define a new index on a single column of a table.
  - CREATE FUNCTION
    Creates custom function that execute user provided code in Cassandra.
  - CREATE KEYSPACE
    Define a new keyspace.
  - CREATE MATERIALIZED VIEW
    Create a materialized view in Cassandra 3.0 and later.
  - CREATE TABLE
    Define a new table.
  - CREATE TRIGGER
    Registers a trigger on a table.
  - CREATE TYPE
    Create a user-defined type in Cassandra 2.1 and later.
  - CREATE ROLE
    Create roles for access control to database objects.
  - CREATE USER (Deprecated)
    Create a new user.
  - DELETE
    Removes data from one or more columns or removes the entire row.
  - DROP AGGREGATE
    Drop a user-defined aggregate.
  - DROP FUNCTION
    Drop user-defined function (UDF).
  - DROP INDEX
    Drop the named index.
  - DROP KEYSPACE
    Remove the keyspace.
  - DROP MATERIALIZED VIEW
    Remove the named materialized view in Cassandra 3.0 and later.
  - DROP ROLE
    Removes a role.
  - DROP TABLE
    Remove the named table.
  - DROP TRIGGER
    Removes registration of a trigger.
  - DROP TYPE
    Drop a user-defined type. Cassandra 2.1 and later.
  - DROP USER (Deprecated)
    Remove a user.
  - GRANT
    Defines resource authorization.
  - INSERT
    Inserts an entire row or upserts data into existing rows.
  - LIST PERMISSIONS
    Lists role permissions on resources.
  - LIST ROLES
    Lists roles and shows superuser and login status.
  - LIST USERS (Deprecated)
    Lists existing internal authentication users and their superuser status.
  - REVOKE
    Remove privileges on database objects from roles.
  - SELECT
    Retrieve data from a Cassandra table.
  - TRUNCATE
    Remove all data from a table.
  - UPDATE
    Update columns in a row.
  - USE
    Connects the client session to a keyspace.

CQL commands

CQL commands.

This section describes the commands that are specific to CQL.

ALTER KEYSPACE
Changes keyspace replication and enable/disable commit log.
ALTER MATERIALIZED VIEW
Changes the table properties of a materialized view, Cassandra 3.0 and later.
ALTER ROLE
Changes password, and set superuser or login options.
ALTER TABLE
Modifies the columns and properties of a table.
ALTER TYPE
Modify a user-defined type. Cassandra 2.1 and later.
ALTER USER
Alter existing user options.
BATCH
Applies multiple data modification language (DML) statements with atomicity and/or in isolation.
CREATE AGGREGATE
Create user-defined aggregate.
CREATE CUSTOM INDEX (SASI)
Generates a SASI index on a single table column.
CREATE INDEX
Define a new index on a single column of a table.
CREATE FUNCTION
Creates custom function that execute user provided code in Cassandra.
CREATE KEYSPACE
Define a new keyspace.
CREATE MATERIALIZED VIEW
Create a materialized view in Cassandra 3.0 and later.
CREATE TABLE
Define a new table.
CREATE TRIGGER
Registers a trigger on a table.
CREATE TYPE
Create a user-defined type in Cassandra 2.1 and later.
CREATE ROLE
Create roles for access control to database objects.
CREATE USER (Deprecated)
Create a new user.
DELETE
Removes data from one or more columns or removes the entire row.
DROP AGGREGATE
Drop a user-defined aggregate.
DROP FUNCTION
Drop user-defined function (UDF).
DROP INDEX
Drop the named index.
DROP KEYSPACE
Remove the keyspace.
DROP MATERIALIZED VIEW
Remove the named materialized view in Cassandra 3.0 and later.
DROP ROLE
Removes a role.
DROP TABLE
Remove the named table.
DROP TRIGGER
Removes registration of a trigger.
DROP TYPE
Drop a user-defined type. Cassandra 2.1 and later.
DROP USER (Deprecated)
Remove a user.
GRANT
Defines resource authorization.
INSERT
Inserts an entire row or upserts data into existing rows.
LIST PERMISSIONS
Lists role permissions on resources.
LIST ROLES
Lists roles and shows superuser and login status.
LIST USERS (Deprecated)
Lists existing internal authentication users and their superuser status.
REVOKE
Remove privileges on database objects from roles.
SELECT
Retrieve data from a Cassandra table.
TRUNCATE
Remove all data from a table.
UPDATE
Update columns in a row.
USE
Connects the client session to a keyspace.

General Inquiries: +1 (650) 389-6000 info@datastax.com

© DataStax | Privacy policy | Terms of use | Updated: 18 February 2022

Build time: 2022-02-18 10:38:55.222

DataStax, Titan, and TitanDB are registered trademarks of DataStax, Inc. and its subsidiaries in the United States and/or other countries.

Apache, Apache Cassandra, Cassandra, Apache Tomcat, Tomcat, Apache Lucene, Apache Solr, Apache Hadoop, Hadoop, Apache Pulsar, Pulsar, Apache Spark, Spark, Apache TinkerPop, TinkerPop, Apache Kafka and Kafka are either registered trademarks or trademarks of the Apache Software Foundation or its subsidiaries in Canada, the United States and/or other countries.

Kubernetes is the registered trademark of the Linux Foundation.

cql-oss osscql3x