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 3.0

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 cqlsh on Linux and Mac OS X
  A brief description on starting cqlsh on Linux and Mac OS X.
- 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 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
  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.
- Altering a table
  How to alter a table to add or delete columns or change table properties.
- 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.
  - Working with legacy applications
    Internally, CQL does not change the row and column mapping from the Thrift API mapping. CQL and Thrift use the same storage engine.
  - Querying a legacy table
  - Using a CQL legacy table query
    Using CQL to query a legacy table.
CQL reference
CQL reference topics.

Legacy tables

How to work with legacy tables.

Legacy tables must be handled differently from currently built CQL tables.

Working with legacy applications
Internally, CQL does not change the row and column mapping from the Thrift API mapping. CQL and Thrift use the same storage engine.
Querying a legacy table
Using a CQL legacy table query
Using CQL to query a legacy table.

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:39:27.682

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 osscql33