DataStax Luna — Enterprise Support for Apache Cassandra. Start a Free 30-Day Trial Now!

Jump to main content

Support
DataStax Home
Downloads

Learn
Drivers
Glossary
Try for free

About CQL
CQL quickstart
CQL quick reference
CQL data modeling
Introduction to CQL commands
Managing keyspaces
Managing types, functions, and aggregates
Managing tables
Querying data
Inserting and updating data
Batching inserts and updates
CQL reference
Cycling keyspace

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

CQL for the DataStax Distribution of Apache Cassandra™ 3.11 Latest DDAC patch: 5.1.19

About CQL
CQL (Cassandra Query Language) is a query language for the DataStax Distribution of Apache Cassandra database.
CQL quickstart
Quickstart for CQL.
CQL quick reference
Provides a consolidated syntax list of Cassandra Query Language (CQL) commands for quick reference.
CQL data modeling
Basic rules to follow when designing a DataStax Distribution of Apache Cassandra database.
Introduction to CQL commands
Shows the CQL command syntax and rules, and provides instruction on using CQL shell (cqlsh).
Managing keyspaces
Create and drop keyspaces. Manage the replication factor (data availability).
Managing types, functions, and aggregates
Create, replace, alter, and drop customized user-defined functions, aggregates, and types.
Managing tables
How to create tables to store data.
Querying data
Retrieve data sets from a table using SELECT statements.
Inserting and updating data
How to insert data into a table with either regular or JSON data.
Batching inserts and updates
Performing multiple writes in the same command.
CQL reference
CQL reference topics.
- Introduction
  About using CQL.
- CQL data types
  Describes CQL column types.
- CQL native functions
  Describes scalar functions that work on values in a single row of data to create a new value.
- CQL native aggregates
  Works on a set of rows matching the SELECT statement to return a single value.
- cqlsh reference
  Commands specific to the Cassandra Query Language shell (cqlsh) utility.
- CQL commands
  CQL commands.
  - ALTER KEYSPACE
    Changes keyspace replication strategy and enables or disables commit log.
  - ALTER MATERIALIZED VIEW
    Changes the table properties of a materialized view.
  - ALTER ROLE
    Changes password and sets superuser or login options.
  - ALTER TABLE
    Modifies the columns and properties of a table.
  - ALTER TYPE
    Modifies an existing user-defined type (UDT).
  - ALTER USER
    Alter existing user options.
  - BATCH
    Applies multiple data modification language (DML) statements with atomicity and/or in isolation.
  - CREATE AGGREGATE
    Defines a user-defined aggregate.
  - CREATE INDEX
    Defines a new index for a single column of a table.
  - CREATE FUNCTION
    Creates custom function to execute user provided code.
  - CREATE KEYSPACE
    Defines a new keyspace.
  - CREATE MATERIALIZED VIEW
    Optimizes read requests and eliminates the need for multiple write requests by duplicating data from a base table.
  - CREATE ROLE
    Creates a cluster wide database object used for access control.
  - CREATE TABLE
    Creates a new table.
  - CREATE TRIGGER
    Registers a trigger on a table.
  - CREATE TYPE
    Creates a custom data type in the keyspace that contains one or more fields of related information
  - CREATE USER (Deprecated)
    Deprecated. Creates a new user.
  - DELETE
    Removes data from one or more columns or removes the entire row.
  - DROP AGGREGATE
    Deletes a user-defined aggregate from a keyspace.
  - DROP FUNCTION
    Deletes a user-defined function (UDF) from a keyspace.
  - DROP INDEX
    Removes an index from a table.
  - DROP KEYSPACE
    Removes the keyspace.
  - DROP MATERIALIZED VIEW
    Removes the named materialized view.
  - DROP ROLE
    Removes a role.
  - DROP TABLE
    Removes the table.
  - DROP TRIGGER
    Removes registration of a trigger.
  - DROP TYPE
    Drop a user-defined type.
  - DROP USER (Deprecated)
    Removes 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.
  - RESTRICT
    Configures the column on which permissions can be granted.
  - REVOKE
    Removes privileges on database objects from roles.
  - SELECT
    Returns data from a table.
  - TRUNCATE
    Removes all data from a table.
  - UNRESTRICT
    Removes the partition key selection for row level access control.
  - UPDATE
    Modifies one or more column values to a row in a table.
  - USE
    Selects the keyspace for the current client session.
Cycling keyspace
CQL commands to set up the cycling examples used in this guide.

CQL commands

CQL commands.

This section describes the commands that are specific to CQL.

ALTER KEYSPACE
Changes keyspace replication strategy and enables or disables commit log.
ALTER MATERIALIZED VIEW
Changes the table properties of a materialized view.
ALTER ROLE
Changes password and sets superuser or login options.
ALTER TABLE
Modifies the columns and properties of a table.
ALTER TYPE
Modifies an existing user-defined type (UDT).
ALTER USER
Alter existing user options.
BATCH
Applies multiple data modification language (DML) statements with atomicity and/or in isolation.
CREATE AGGREGATE
Defines a user-defined aggregate.
CREATE INDEX
Defines a new index for a single column of a table.
CREATE FUNCTION
Creates custom function to execute user provided code.
CREATE KEYSPACE
Defines a new keyspace.
CREATE MATERIALIZED VIEW
Optimizes read requests and eliminates the need for multiple write requests by duplicating data from a base table.
CREATE ROLE
Creates a cluster wide database object used for access control.
CREATE TABLE
Creates a new table.
CREATE TRIGGER
Registers a trigger on a table.
CREATE TYPE
Creates a custom data type in the keyspace that contains one or more fields of related information
CREATE USER (Deprecated)
Deprecated. Creates a new user.
DELETE
Removes data from one or more columns or removes the entire row.
DROP AGGREGATE
Deletes a user-defined aggregate from a keyspace.
DROP FUNCTION
Deletes a user-defined function (UDF) from a keyspace.
DROP INDEX
Removes an index from a table.
DROP KEYSPACE
Removes the keyspace.
DROP MATERIALIZED VIEW
Removes the named materialized view.
DROP ROLE
Removes a role.
DROP TABLE
Removes the table.
DROP TRIGGER
Removes registration of a trigger.
DROP TYPE
Drop a user-defined type.
DROP USER (Deprecated)
Removes 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.
RESTRICT
Configures the column on which permissions can be granted.
REVOKE
Removes privileges on database objects from roles.
SELECT
Returns data from a table.
TRUNCATE
Removes all data from a table.
UNRESTRICT
Removes the partition key selection for row level access control.
UPDATE
Modifies one or more column values to a row in a table.
USE
Selects the keyspace for the current client session.

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

© DataStax | Privacy policy | Terms of use | Updated: 21 August 2020

Build time: 2020-08-21 07:00:34.289

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

ddaccql ddaccql51