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

Introduction to Cassandra Query Language
Cassandra Query Language (CQL) is a query language for the Apache Cassandra database.
CQL data modeling
Data modeling topics.
Using CQL
CQL provides an API to Apache Cassandra that is simpler than the Thrift API for new applications.
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.
- CQL keyspace and table properties
  About using CQL keyspace and table properties.
- Functions
  CQL support functions for transforming one or more column values into a new value.
- CQL limits
  Upper CQL limits.
- cqlsh commands
  The cqlsh commands.
- CQL commands
  CQL commands.
  - ALTER KEYSPACE
    Change property values of a keyspace.
  - ALTER TABLE
    Modify the column metadata of a table.
  - ALTER TYPE
    Modify a user-defined type. Apache Cassandra™ 2.1 and later.
  - ALTER USER
    Alter existing user options.
  - BATCH
    Write multiple DML statements.
  - CREATE INDEX
    Define a new index on a single column of a table.
  - CREATE KEYSPACE
    Define a new keyspace and its replica placement strategy.
  - CREATE TABLE
    Define a new table.
  - CREATE TRIGGER
    Registers a trigger on a table.
  - CREATE TYPE
    Create a user-defined type. Apache Cassandra 2.1 and later.
  - CREATE USER
    Create a new user.
  - DELETE
    Removes entire rows or one or more columns from one or more rows.
  - DROP INDEX
    Drop the named index.
  - DROP KEYSPACE
    Remove the keyspace.
  - DROP TABLE
    Remove the named table.
  - DROP TRIGGER
    Removes registration of a trigger.
  - DROP TYPE
    Drop a user-defined type. Apache Cassandra 2.1 and later.
  - DROP USER
    Remove a user.
  - GRANT
    Provide access to database objects.
  - INSERT
    Add or update columns.
  - LIST PERMISSIONS
    List permissions granted to a user.
  - LIST USERS
    List existing users and their superuser status.
  - REVOKE
    Revoke user permissions.
  - SELECT
    Retrieve data from a Cassandra table.
  - TRUNCATE
    Remove all data from a table.
  - UPDATE
    Update columns in a row.
  - USE
    Connect the client session to a keyspace.

CQL commands

CQL commands.

ALTER KEYSPACE
Change property values of a keyspace.
ALTER TABLE
Modify the column metadata of a table.
ALTER TYPE
Modify a user-defined type. Apache Cassandra™ 2.1 and later.
ALTER USER
Alter existing user options.
BATCH
Write multiple DML statements.
CREATE INDEX
Define a new index on a single column of a table.
CREATE KEYSPACE
Define a new keyspace and its replica placement strategy.
CREATE TABLE
Define a new table.
CREATE TRIGGER
Registers a trigger on a table.
CREATE TYPE
Create a user-defined type. Apache Cassandra 2.1 and later.
CREATE USER
Create a new user.
DELETE
Removes entire rows or one or more columns from one or more rows.
DROP INDEX
Drop the named index.
DROP KEYSPACE
Remove the keyspace.
DROP TABLE
Remove the named table.
DROP TRIGGER
Removes registration of a trigger.
DROP TYPE
Drop a user-defined type. Apache Cassandra 2.1 and later.
DROP USER
Remove a user.
GRANT
Provide access to database objects.
INSERT
Add or update columns.
LIST PERMISSIONS
List permissions granted to a user.
LIST USERS
List existing users and their superuser status.
REVOKE
Revoke user permissions.
SELECT
Retrieve data from a Cassandra table.
TRUNCATE
Remove all data from a table.
UPDATE
Update columns in a row.
USE
Connect the client session to a keyspace.

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

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

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 osscql31