DataStax Luna — Enterprise Support for Apache Cassandra. Start a Free 30-Day Trial Now!
Can't find what you're looking for? Try searching other guides
CQL (Cassandra Query Language) is a query language for the DataStax Distribution of Apache Cassandra database.
Quickstart for CQL.
Introduction to CQL and data modeling.
Run CQL commands using CQL shell.
Introduction to data modeling.
Add a keyspace and set the replication factor.
Create a table with a simple primary key and populate it with data.
Create a table with a compound primary key and populate it with data.
Create a table with a composite partition key and populate it with data.
Create a secondary index on a column.
The UPDATE statement writes one or more column values to a row.
UPDATE
The DELETE statement removes data from one or more columns, or removes an entire row. The TRUNCATE statement removes all data from a table.
DELETE
TRUNCATE
The DROP TABLE statement removes a table and the table data. The DROP KEYSPACE statement removes the keyspace and all of the objects in the keyspace.
DROP TABLE
DROP KEYSPACE
Increase your knowledge of CQL and data modeling.
Provides a consolidated syntax list of Cassandra Query Language (CQL) commands for quick reference.
Basic rules to follow when designing a DataStax Distribution of Apache Cassandra database.
Shows the CQL command syntax and rules, and provides instruction on using CQL shell (cqlsh).
Create and drop keyspaces. Manage the replication factor (data availability).
Create, replace, alter, and drop customized user-defined functions, aggregates, and types.
How to create tables to store data.
Retrieve data sets from a table using SELECT statements.
How to insert data into a table with either regular or JSON data.
Performing multiple writes in the same command.
CQL reference topics.
CQL commands to set up the cycling examples used in this guide.