Arithmetic operators

CQL supports these arithmetic operators:

Operator Description

Operator	Description
`-`	Use the minus symbol for either the unary negate operand or subtraction.
`+`	Use the plus symbol for addition.
`*`	Use the asterisk symbol for multiplication.
`/`	Use the forward slash symbol for division.
`%`	Use the percent symbol to return the remainder from division.

-

Use the minus symbol for either the unary negate operand or subtraction.

+

Use the plus symbol for addition.

*

Use the asterisk symbol for multiplication.

/

Use the forward slash symbol for division.

%

Use the percent symbol to return the remainder from division.

The *, /, and % operators have a higher precedence than the + and - operators. Higher precedence operators are evaluated before lower precedence operators. If two operators in an expression have the same precedence, they are evaluated from left to right based on the operator position in the expression.

Return types

The return type of an arithmetic expression is based on the types of the input operands. In the following table, left and right refer to the type of the operand on the left and right of the operator. For example, in the expression a + b, a is the left operand and b is the right operand; if a is an int operand and b is a float operand, a float is returned.

left/right

tinyint

smallint

int

bigint

counter

float

double

varint

decimal

tinyint

tinyint

smallint

int

bigint

float

double

varint

decimal

smallint

smallint

int

bigint

float

double

varint

decimal

int

int

bigint

float

double

varint

decimal

bigint

bigint

double

varint

decimal

counter

bigint

double

varint

decimal

float

float

double

float

double

decimal

double

double

decimal

varint

varint

decimal

decimal

decimal

Dates and times

A time duration can be added (+) or subtracted (-) from a timestamp or a date to create a new timestamp or date. For example, the following query returns cycling races that occur one day before the supplied date:

SELECT * FROM cycling.race_times
  WHERE race_date = '2017-04-15' - 1d;

Multiple columns

Multiple columns can be used in an expression, as shown in the following queries:

SELECT (emp_id + dept_id) / age FROM cycling.mechanic;

Non-arithmetic operators

CQL supports the following non-arithmetic operators:

Operator Description

Operator	Description
`CONTAINS`	Use to find a value in a collection .
`CONTAINS`	Use to find a key in a map collection.
`IN`	Use to find a value included in the specified list of values.
`LIKE`	Use to find a value that matches a pattern if a fuzzy search is enabled.

CONTAINS

Use to find a value in a collection .

CONTAINS

Use to find a key in a map collection.

IN

Use to find a value included in the specified list of values.

LIKE

Use to find a value that matches a pattern if a fuzzy search is enabled.

Arithmetic operators

Return types

Dates and times

Multiple columns

Non-arithmetic operators

Was this helpful?

Give Feedback