Operators [YCQL]

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.