Jump to main content
DataStax LunaEnterprise Support for Apache Cassandra  —  Start a Free 30-Day Trial Now.
Introduction to Cassandra Query Language
Cassandra Query Language (CQL) is a query language for the Cassandra database.
Data modeling topics.
Data modeling concepts
How data modeling should be approached for Cassandra. A Pro Cycling statistics example is used throughout the CQL document.
Data modeling analysis
How to analyze a logical data model.
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.
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 topics.
About using CQL.
CQL lexical structure
CQL input consists of statements that change data, look up data, store data, or change the way data is stored.
CQL data types
Built-in data types for columns.
CQL support functions for transforming one or more column values into a new value.
CQL limits
Upper CQL limits.
CQL shell commands
The CQL shell (cqlsh utility) commands.
CQL commands
CQL commands.