YCQL operators
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 afalse
value. OperatorISNULL
orIS NULL
must be used when comparing withNULL
. - When
+
and-
are applied to a NULL argument ofCOUNTER
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.