DataStax Luna  —  Support for Open-Source Apache Cassandra. Start a Free 30-Day Trial Now!

Jump to main content
DataStax Home Page
  • Support
  • DataStax Home
  • Downloads
  • Learn
    • Academy
    • Community
    • Blog
    • Resource library
    • Examples on GitHub
  • Drivers
    • Driver home page
    • C++ Driver Guide
    • C# Driver Guide
    • Java Driver Guide
    • Node.js Driver Guide
    • Python Driver Guide
  • Glossary
  • world icon
  • Try for free
  • About CQL
  • CQL quickstart
  • CQL quick reference
  • CQL data modeling
  • Introduction to CQL commands
  • Managing keyspaces
  • Managing types, functions, and aggregates
  • Managing tables
  • Querying data
  • Inserting and updating data
  • Batching inserts and updates
  • CQL reference
  • Cycling keyspace

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

CQL for the DataStax Distribution of Apache Cassandra™ 3.11 Latest DDAC patch: 5.1.19
  • About CQL

    CQL (Cassandra Query Language) is a query language for the DataStax Distribution of Apache Cassandra database.

  • CQL quickstart

    Quickstart for CQL.

    • Introduction

      Introduction to CQL and data modeling.

    • Running CQL commands

      Run CQL commands using CQL shell.

    • Data modeling

      Introduction to data modeling.

    • Creating a keyspace

      Add a keyspace and set the replication factor.

    • Creating a table with a simple primary key

      Create a table with a simple primary key and populate it with data.

    • Creating a table with a compound primary key

      Create a table with a compound primary key and populate it with data.

    • Creating a table with a composite partition key

      Create a table with a composite partition key and populate it with data.

    • Using a secondary index

      Create a secondary index on a column.

    • Updating data

      The UPDATE statement writes one or more column values to a row.

    • Deleting and truncating data

      The DELETE statement removes data from one or more columns, or removes an entire row. The TRUNCATE statement removes all data from a table.

    • Dropping tables and keyspaces

      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.

    • Increase your knowledge

      Increase your knowledge of CQL and data modeling.

  • 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 Distribution of Apache Cassandra database.

  • Introduction to CQL commands

    Shows the CQL command syntax and rules, and provides instruction on using CQL shell (cqlsh).

  • Managing keyspaces

    Create and drop keyspaces. Manage the replication factor (data availability).

  • Managing types, functions, and aggregates

    Create, replace, alter, and drop customized user-defined functions, aggregates, and types.

  • Managing tables

    How to create tables to store data.

  • Querying data

    Retrieve data sets from a table using SELECT statements.

  • Inserting and updating data

    How to insert data into a table with either regular or JSON data.

  • Batching inserts and updates

    Performing multiple writes in the same command.

  • CQL reference

    CQL reference topics.

  • Cycling keyspace

    CQL commands to set up the cycling examples used in this guide.

Increase your knowledge

Increase your knowledge of CQL and data modeling.

See these documents for more information:

  • Introduction to CQL commands
  • CQL reference
  • CQL data modeling
  • CQL quick reference
  • DataStax Bulk Loader (Loads data from CSV or JSON files into the database.)

DataStax Academy also has online classes about CQL and data modeling. See academy.datastax.com.

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

© DataStax | Privacy policy | Terms of use | Updated: 20 August 2020

Build time: 2020-08-20 15:57:55.526

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 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.

ddaccql ddaccql51