YCQL operators

This page documents the preview version (v2.23). Preview includes features under active development and is for development and testing only. For production, use the stable version (v2024.1). To learn more, see Versioning.

An expression with operators is a compound expression that combines multiple expressions using built-in operators. The following sections discuss the YCQL operators in YugabyteDB.

Null operators

Operator Description
EXISTS, NOT EXISTS predicate for existence of a row

EXISTS and NOT EXISTS can only be used in the IF clause.

Unary operators

Operator Description
- numeric negation
+ no-op
NOT Logical (boolean) negation

Unary - and + can only be used with constant expressions such as -77.

Binary operators

Operator Description
OR, AND Logical (boolean) expression
=, !=, <, <=, >, >= Comparison expression
+ Addition, append, or prepend
- Subtraction or removal
* Multiplication. Not yet supported
/ Division. Not yet supported
ISNULL, IS NOT NULL Not yet supported comparison expression.
  • The first argument of comparison operators must be a column. For example, column_name = 7.
  • Comparing NULL with others always yields a false value. Operator ISNULL or IS NULL must be used when comparing with NULL.
  • When + and - are applied to a NULL argument of COUNTER data type, the NULL expression is replaced with a zero value before the computation. When these operators are applied to a NULL expression of all other numeric data types, the computed value is always NULL.
  • Operator + either prepends or appends a value to a LIST while operator - removes elements from LIST.
  • Operator + inserts new distinct elements to a MAP or SET while operator - removes elements from them.