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 columns in a table
    Adding or changing columns to a table with the ALTER TABLE command.
  - Altering a table to add a collection
    Adding or changing collection columns to a table with the ALTER TABLE command.
  - Altering the data type of a column
    Changing the data type of a column after it is defined or added to a table using ALTER TABLE.
  - Altering the table properties
    Changing the table properties after the table properties are defined or adding table properties to a table using ALTER TABLE.
- 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.

Altering a table

How to alter a table to add or delete columns or change table properties.

Tables can be changed with the ALTER command.

Altering columns in a table
Adding or changing columns to a table with the ALTER TABLE command.
Altering a table to add a collection
Adding or changing collection columns to a table with the ALTER TABLE command.
Altering the data type of a column
Changing the data type of a column after it is defined or added to a table using ALTER TABLE.
Altering the table properties
Changing the table properties after the table properties are defined or adding table properties to a table using ALTER 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