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.
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.
- Setting up the Cycling keyspace
  CQL commands to set up the cycling keyspace and examples used in this guide.
  - User-defined types
    User defined type examples used in the DataStax Enterprise documentation set.
    - basic_info
      User-defined type that contains fields for basic information about a cyclist such as birthday, nationality, height, and weight.
    - basic_info_withTTL
      User-defined type that contains fields for basic information about a cyclist such as birthday, nationality, height, and weight.
    - fullname
      User-defined type that contains two fields for first name and last name.
    - race
      User-defined type that contains three fields for a race name, date, and time.
  - Tables
    CQL commands that create cycling example tables and insert the corresponding data.
  - Cycling queries
    Querying the cycling keyspace tables.
  - Cycling user-defined functions
    Sample user-defined functions and aggregates.
  - Search index
    Search index examples using the cycling tables.
  - Index
    Experimental secondary index.
  - Access control
    Roles and access control for the cycling keyspace with different authentication and authorization models.

Cycling types

User defined type examples used in the DataStax Enterprise documentation set.

User defined type examples used in the DataStax Enterprise documentation set.

basic_info
User-defined type that contains fields for basic information about a cyclist such as birthday, nationality, height, and weight.
basic_info_withTTL
User-defined type that contains fields for basic information about a cyclist such as birthday, nationality, height, and weight.
fullname
User-defined type that contains two fields for first name and last name.
race
User-defined type that contains three fields for a race name, date, and time.

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