Have a question or want live help from a DataStax engineer? Let's chat.

Jump to main content
DataStax Home Page
  • Support
  • DataStax Home
  • Downloads
  • Learn
    • Academy
    • Developers
    • 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
  • Get Live Help
  • Introduction to Cassandra Query Language
  • CQL data modeling
  • Using CQL
  • CQL reference

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

CQL for Apache Cassandra 3.0
  • Introduction to Cassandra Query Language

    Cassandra Query Language (CQL) is a query language for the Cassandra database.

  • CQL data modeling

    Data modeling topics.

  • Using CQL

    CQL provides an API to Cassandra that is simpler than the Thrift API.

  • CQL reference

    CQL reference topics.

    • Introduction

      About using CQL.

    • CQL lexical structure

      CQL input consists of statements that change data, look up data, store data, or change the way data is stored.

    • CQL data types

      Built-in data types for columns.

    • Functions

      CQL support functions for transforming one or more column values into a new value.

    • CQL limits

      Upper CQL limits.

    • CQL shell commands

      The CQL shell (cqlsh utility) commands.

    • CQL commands

      CQL commands.

Functions

CQL support functions for transforming one or more column values into a new value.

CQL supports several functions that transform one or more column values into a new value. In addition, users can define functions and aggregates. The native Cassandra functions are:
  • Blob conversion functions
  • UUID and Timeuuid functions
  • Token function
  • WRITETIME function
  • TTL function
  • Standard aggregate functions such as MIN(), MAX(), SUM(), and AVG().
  • TOKEN function

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

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

Build time: 2022-02-18 10:39:27.682

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.

cql-oss osscql33