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.
- Starting the CQL shell (cqlsh)
  How to start the CQL shell (cqlsh).
- Creating and updating a keyspace
  Creating a keyspace is the CQL counterpart to creating an SQL database.
- Creating a table
  How to create tables to store data.
- Creating a materialized view
  How to create CQL materialized views.
- Creating advanced data types in tables
  How to create collections and user defined types (UDTs) in tables.
- Creating functions
  How to create functions.
- Inserting and updating data
  How to insert data into a table with either regular or JSON data.
- Batching data insertion and updates
  How to batch insert or update data into a table.
- Querying tables
  How to query data from tables.
- Indexing tables
  How to query data from tables using indexes.
  - Indexing
    An index provides a means to access data in Cassandra using attributes other than the partition key for fast, efficient lookup of data matching a given condition.
  - Indexing with SASI
    Explain what a SSTable Attached Secondary Index (SASI) is.
  - Building and maintaining indexes
    Indexes provide operational ease for populating and maintaining the index.
- Altering a table
  How to alter a table to add or delete columns or change table properties.
- Altering a materialized view
  Altering the properties of a materialized view with the ALTER MATERIALIZED VIEW command.
- Altering a user-defined type
  Adding columns to a user-defined type with the ALTER TYPE command.
- Removing a keyspace, schema, or data
  Using the DROP and DELETE commands.
- Securing a table
  How to secure a table.
- Tracing consistency changes
  This tutorial shows the difference between these consistency levels and the number of replicas that participate to satisfy a request.
- Displaying rows from an unordered partitioner with the TOKEN function
  How to use CQL to display rows from an unordered partitioner.
- Determining time-to-live (TTL) for a column
  How to insert and retrieve data pertaining to TTL for columns.
- Determining the date/time of a write
  Using the WRITETIME function in a SELECT statement to determine when the date/time that the column was written to the database.
- Legacy tables
  How to work with legacy tables.
CQL reference
CQL reference topics.

Indexing tables

How to query data from tables using indexes.

Data can be queried from tables using indexes, once created.

Indexing
An index provides a means to access data in Cassandra using attributes other than the partition key for fast, efficient lookup of data matching a given condition.
Indexing with SSTable attached secondary indexes (SASI)
Explain what a 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: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