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

About CQL
CQL quick reference
CQL data modeling
Introduction to CQL
Managing database resources
Inserting and updating data
Querying data
cqlsh reference
CQL reference
Examples

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

CQL for DataStax Enterprise 6.7 Previous DSE version Latest 6.7 patch: 6.7.x

About CQL
CQL (Cassandra Query Language) is a query language for the DataStax Enterprise database.
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 Enterprise database.
Introduction to CQL
Shows the CQL command syntax and rules, and provides instruction on using CQL shell (cqlsh).
Managing database resources
Create, alter, and drop keyspaces, tables, functions, and search indexes.
- Keyspaces
  Create and drop keyspaces, and manage the replication factor (data availability).
- Types, functions and aggregates
  Create, replace, alter, and drop customized user-defined functions, aggregates, and types.
- Tables
  How to create tables to store data.
  - Creating a table
    How to create CQL tables.
  - Creating a counter table
    A counter is a special column for storing a number that is changed in increments.
  - Fixing a table schema collision
    How to fix schema collision problems.
  - Altering a table
    Add or delete columns and change table properties.
    - Modify table columns
      Add, drop, or rename table columns.
    - Altering a table to add a collection
      Add collection columns to a table or change existing collection columns with the ALTER TABLE command.
    - Altering table properties
      Change the table properties after the table properties are defined or add table properties to a table with the ALTER TABLE command.
  - Dropping a keyspace or table
    Use the DROP KEYSPACE or DROP TABLE command to drop a keyspace or table.
  - Indexing tables
    How to query data from tables using indexes.
- Search Indexes
  Create and configure a search index on an existing table.
Inserting and updating data
How to insert data into a table with either regular or JSON data.
Querying data
Retrieve data sets from a table using SELECT statements.
cqlsh reference
Commands specific to the Cassandra Query Language shell (cqlsh) utility.
CQL reference
Provides a brief description and syntax for CQL statements, types, operators, and functions supported by the DataStax Enterprise database.
Examples
CQL description of keyspaces, tables and other database resources used in CQL examples.

Altering a table

Add or delete columns and change table properties.

Change tables using the ALTER command.

Modify table columns
Add, drop, or rename table columns.
Altering a table to add a collection
Add collection columns to a table or change existing collection columns with the ALTER TABLE command.
Altering table properties
Change the table properties after the table properties are defined or add table properties to a table with the ALTER TABLE command.

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:02:58.902

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 cql67