• HOME
  • ACADEMY
  • DOCS
CONTACT US DOWNLOAD DATASTAX
DataStax Logo
  • GLOSSARY
  • SUPPORT
  • DEVELOPER BLOGS
This document is no longer maintained.
CQL for Apache Cassandra 3.0
  • Introduction to Cassandra Query Language
  • CQL data modeling
    • Data modeling concepts
    • Data modeling analysis
    • Using materialized views
      • Understanding materialized views
      • Known limitations
      • Creating a materialized view
      • Altering a materialized view
      • Dropping a materialized view
      • Best practices
      • FAQ
  • Using CQL
    • Starting cqlsh on Linux and Mac OS X
    • Creating and updating a keyspace
      • Example of creating a keyspace
      • Updating the replication factor
    • Creating a table
      • Creating a table
      • Using the keyspace qualifier
      • Simple Primary Key
      • Composite Partition Key
      • Compound Primary Key
      • Creating a counter table
      • Create table with COMPACT STORAGE
      • Migrating from compact storage
      • Table schema collision fix
    • Creating advanced data types in tables
      • Creating collections
      • Creating a table with a tuple
      • Creating a user-defined type (UDT)
    • Creating functions
      • Creating user-defined function (UDF)
      • Creating User-Defined Aggregate Function (UDA)
    • Inserting and updating data
      • Inserting simple data into a table
      • Inserting and updating data into a set
      • Inserting and updating data into a list
      • Inserting and updating data into a map
      • Inserting tuple data into a table
      • Inserting or updating data into a user-defined type (UDT)
      • Inserting JSON data into a table
      • Using lightweight transactions
      • Sharing a static column
      • Expiring data with time-to-live
    • Batching data insertion and updates
      • Batching inserts, updates and deletes
      • Good use of BATCH statement
      • Misuse of BATCH statement
    • Querying tables
      • Retrieval and sorting results
      • Retrieval using collections
      • Retrieval using JSON
      • Retrieval using the IN keyword
      • Retrieval by scanning a partition
      • Retrieval using standard aggregate functions
      • Retrieval using a user-defined function (UDF)
      • Retrieval using user-defined aggregate (UDA) functions
      • Querying a system table
    • Indexing
      • When to use an index
      • Using a secondary index
      • Using multiple indexes
      • Indexing a collection
    • Altering a table
      • Altering columns in a table
      • Altering a table to add a collection
      • Altering the data type of a column
      • Altering the table properties
    • Altering a user-defined type
    • Removing a keyspace, schema, or data
      • Dropping a keyspace or table
      • Deleting columns and rows
      • Dropping a user-defined function (UDF)
    • Securing a table
      • Database roles
      • Database Permissions
      • Database users
    • Tracing consistency changes
      • Setup to trace consistency changes
      • Trace reads at different consistency levels
      • How consistency affects performance
    • Displaying rows from an unordered partitioner with the TOKEN function
    • Determining time-to-live (TTL) for a column
    • Determining the date/time of a write
    • Legacy tables
      • Working with legacy applications
      • Querying a legacy table
      • Using a CQL legacy table query
  • CQL reference
    • Introduction
    • CQL lexical structure
      • Uppercase and lowercase
      • Escaping characters
      • Valid literals
      • Exponential notation
      • CQL code comments
      • CQL Keywords
    • CQL data types
      • Blob type
      • Collection type
      • Counter type
      • UUID and timeuuid types
      • UUID and timeuuid functions
      • Timestamp type
      • Tuple type
      • User-defined type
    • Functions
    • CQL limits
    • CQL shell commands
      • Starting cqlsh
      • Configuring cqlsh from a file
      • CAPTURE
      • CLEAR
      • CONSISTENCY
      • COPY
      • DESCRIBE
      • cqlshExpand
      • EXIT
      • LOGIN
      • PAGING
      • SERIAL CONSISTENCY
      • SHOW
      • SOURCE
      • TRACING
    • CQL commands
      • ALTER KEYSPACE
      • ALTER MATERIALIZED VIEW
      • ALTER ROLE
      • ALTER TABLE
      • ALTER TYPE
      • ALTER USER
      • BATCH
      • CREATE AGGREGATE
      • CREATE INDEX
      • CREATE FUNCTION
      • CREATE KEYSPACE
      • CREATE MATERIALIZED VIEW
      • CREATE TABLE
      • CREATE TRIGGER
      • CREATE TYPE
      • CREATE ROLE
      • CREATE USER (Deprecated)
      • DELETE
      • DROP AGGREGATE
      • DROP FUNCTION
      • DROP INDEX
      • DROP KEYSPACE
      • DROP MATERIALIZED VIEW
      • DROP ROLE
      • DROP TABLE
      • DROP TRIGGER
      • DROP TYPE
      • DROP USER (Deprecated)
      • GRANT
      • INSERT
      • LIST PERMISSIONS
      • LIST ROLES
      • LIST USERS (Deprecated)
      • REVOKE
      • SELECT
      • TRUNCATE
      • UPDATE
      • USE
  • Home
  • Academy
  • Docs home
  • Contact us
  • Download DataStax
  • Glossary
  • Support
  • Developer blogs
  1. Home
  2. CQL reference
  3. Functions

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
  • CQL reference
    • Introduction
    • CQL lexical structure
    • CQL data types
    • Functions
    • CQL limits
    • CQL shell commands
    • CQL commands
© DataStax, Inc. All rights reserved. Updated: 13 December 2019 Build time: 13 December 2019 14:18:24.442

DataStax, Titan, and TitanDB are registered trademark of DataStax, Inc. and its subsidiaries in the United States and/or other countries.

Apache Cassandra, Apache, Tomcat, Lucene, Solr, Hadoop, Spark, TinkerPop, and Cassandra are trademarks of the Apache Software Foundation or its subsidiaries in Canada, the United States and/or other countries.