Have a question or want live help from a DataStax engineer? Let's chat.
Can't find what you're looking for? Try searching other guides
Cassandra Query Language (CQL) is a query language for the Cassandra database.
Data modeling topics.
CQL provides an API to Cassandra that is simpler than the Thrift API.
How to start the CQL shell (cqlsh).
A brief description on starting cqlsh on Linux and Mac OS X.
Creating a keyspace is the CQL counterpart to creating an SQL database.
How to create tables to store data.
How to create CQL materialized views.
How to create collections and user defined types (UDTs) in tables.
How to create functions.
How to insert data into a table with either regular or JSON data.
How to batch insert or update data into a table.
How to query data from tables.
How to query data from tables using indexes.
How to alter a table to add or delete columns or change table properties.
Altering the properties of a materialized view with the ALTER MATERIALIZED VIEW command.
Adding columns to a user-defined type with the ALTER TYPE command.
Using the DROP and DELETE commands.
How to secure a table.
This tutorial shows the difference between these consistency levels and the number of replicas that participate to satisfy a request.
How to use CQL to display rows from an unordered partitioner.
How to insert and retrieve data pertaining to TTL for columns.
Using the WRITETIME function in a SELECT statement to determine when the date/time that the column was written to the database.
How to work with legacy tables.
CQL reference topics.
