All Operators
Scalar operators
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.
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. |
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 |
Last modified 10mo ago