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.0 Earlier DSE version Latest 6.0 patch: 6.0.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.
  - 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.
    - Indexing
      An index provides a means to access data in DataStax Enterprise using attributes other than the partition key for fast, efficient lookup of data that matches a given condition.
    - Indexing with SASI
      Explains what an SSTable Attached Secondary Index (SASI) is.
    - Building and maintaining indexes
      Indexes provide operational ease for populating and maintaining the index.
- 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.

Indexing tables

How to query data from tables using indexes.

After an index is created, data can be queried using the index.

Indexing
An index provides a means to access data in DataStax Enterprise using attributes other than the partition key for fast, efficient lookup of data that matches a given condition.
Indexing with SSTable attached secondary indexes (SASI)
Explains what an SSTable Attached Secondary Index (SASI) is.
Building and maintaining indexes
Indexes provide operational ease for populating and maintaining the index.

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:01:36.221

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 cql60