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

About CQL
CQL quick reference
CQL data modeling
Introduction to CQL
Managing database resources
Using materialized views
Inserting and updating data
Querying data
cqlsh reference
CQL reference
Examples

Can't find what you're looking for? Try searching other guides

CQL for DataStax Astra

About CQL
CQL (Cassandra Query Language) is a query language for the DataStax Enterprise database.
CQL quick reference
Provides a consolidated syntax list of Cassandra Query Language (CQL) commands for quick reference.
CQL data modeling
Basic rules to follow when designing a DataStax Enterprise database.
Introduction to CQL
Shows the CQL command syntax and rules, and provides instruction on using CQL shell (cqlsh).
Managing database resources
Create, alter, and drop keyspaces, tables, functions, and search indexes.
- Keyspaces
  Create and drop keyspaces, and manage the replication factor (data availability).
- Modifying a user-defined type (UDT)
  Add or rename fields to a user-defined type (UDT) with the ALTER TYPE command.
- Tables
  How to create tables to store data.
  - Creating a table
    How to create CQL tables.
    - Defining a basic primary key
      A simple primary key consists of only the partition key that determines which node stores the data.
    - Defining a multi-column partition key
      A partition key can have a partition key defined with multiple table columns which determines which node stores the data.
    - Defining a partition key with clustering columns
      A compound primary key consists of a partition key that determines which node stores the data and of clustering columns that determine the order of the data on the partition.
    - Using advanced data types for columns
      Create columns using advanced data types, such as tuples, maps, lists, and user-defined types (UDTs) in tables.
      - Creating collections
        Collection types provide a way to group and store data together in a table column.
      - Creating a blob column
        Blob data type represents a constant hexadecimal number.
      - Using UUID and timeuuid types
        The UUID (universally unique id) comparator type for avoiding collisions in column names.
      - Tuple type
        Use a tuple as an alternative to a user-defined type.
      - User-defined type
        A user-defined type facilitates handling multiple fields of related information in a table.
      - Creating columns with a single value (static column)
        In a table that uses clustering columns, non-clustering columns can be declared static in the table definition.
  - Creating a counter table
    A counter is a special column for storing a number that is changed in increments.
  - Fixing a table schema collision
    How to fix schema collision problems.
  - Altering a table
    Add or delete columns and change table properties.
  - Dropping a keyspace or table
    Use the DROP KEYSPACE or DROP TABLE command to drop a keyspace or table.
  - Indexing tables
    How to query data from tables using indexes.
- Search Indexes
  Create and configure a search index on an existing table.
Using materialized views
Learn about materialized views, which are tables with data that is automatically inserted and updated from another base table.
Inserting and updating data
How to insert data into a table with either regular or JSON data.
Querying data
Retrieve data sets from a table using SELECT statements.
cqlsh reference
Commands specific to the Cassandra Query Language shell (cqlsh) utility.
CQL reference
Provides a brief description and syntax for CQL statements, types, operators, and functions supported by the DataStax Astra database.
Examples
CQL description of keyspaces, tables and other database resources used in CQL examples.

Using advanced data types for columns

Create columns using advanced data types, such as tuples, maps, lists, and user-defined types (UDTs) in tables.

Creating collections
Collection types provide a way to group and store data together in a table column.
Creating a blob column
Blob data type represents a constant hexadecimal number.
Using UUID and timeuuid types
The UUID (universally unique id) comparator type for avoiding collisions in column names.
Tuple type
Use a tuple as an alternative to a user-defined type.
User-defined type
A user-defined type facilitates handling multiple fields of related information in a table.
Creating columns with a single value (static column)
In a table that uses clustering columns, non-clustering columns can be declared static in the table definition.

General Inquiries: +1 (650) 389-6000 info@datastax.com

© DataStax | Privacy policy | Terms of use | Updated: 25 February 2022

Build time: 2022-02-25 11:36:20.392

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.

astra-cql astracql