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 table
    How to create CQL tables.
  - Using the keyspace qualifier
    To simplify tracking multiple keyspaces, use the keyspace qualifier instead of the USE statement.
  - Simple Primary Key
    A simple primary key consists of only the partition key which determines which node stores the data.
  - Composite Partition Key
    A partition key can have a partition key defined with multiple table columns which determines which node stores the data.
  - Compound Primary Key
    A compound primary key consists of a partition key that determines which node stores the data and of clustering column(s) which determine the order of the data on the partition.
  - Creating a counter table
    A counter is a special column for storing a number that is changed in increments.
  - Create table with COMPACT STORAGE
    Create a table that is compatible with the legacy (Thrift) storage engine format.
  - Table schema collision fix
    How to fix schema collision problems.
- 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.
- 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.

Creating a table

How to create tables to store data.

In CQL, data is stored in tables containing rows of columns.

Creating a table
How to create CQL tables.
Using the keyspace qualifier
To simplify tracking multiple keyspaces, use the keyspace qualifier instead of the USE statement.
Simple Primary Key
A simple primary key consists of only the partition key which determines which node stores the data.
Composite Partition Key
A partition key can have a partition key defined with multiple table columns which determines which node stores the data.
Compound Primary Key
A compound primary key consists of a partition key that determines which node stores the data and of clustering column(s) which determine the order of the data on the partition.
Creating a counter table
A counter is a special column for storing a number that is changed in increments.
Create table with COMPACT STORAGE
Create a table that is compatible with the legacy (Thrift) storage engine format.
Table schema collision fix
How to fix schema collision problems.

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