Search
K
Links

All Operators

Scalar operators

Operators Overview

Operators in the Arize Query Language typically operate on one or two values and return a result based on the values. Different operators can apply to different dimensions and constant types.

Types of Operators

Numeric Operators

Arithmetic operators only operate on numeric dimensions.
Operator
Description
A + B
Plus
A - B
Minus
A * B
Multiply
A / B
Divide (integer division is cast to FLOAT)
ABS(A)
Absolute value
CEIL
Round to nearest int
FLOOR
Round down to nearest int
COS
Cosine
SIN
Sine
TAN
Tangent
TANH
Hyperbolic tangent
LN
Natural log (base e)
LOG
Natural log (base e)
LOG10
Log base 10
SQRT
Square root
CBRT
Cube root
GREATEST
Returns the greatest value of the arguments. Returns null if any argument is null.
LEAST
Returns the least value of the arguments. Returns null if any argument is null.

Comparison Operators

These general operators can apply to strings and numerics alike.
Operator
Description
A = B
Equal to
A <> B
Not equal
A != B
Not equal
A > B
Greater than
A <= B
Greater than or equal to
A < B
Less than
A <= B
Less than or equal to