| Function | Support | Notes |
|---|---|---|
ABS | Supported | |
SIGN | Supported | |
CEIL | Supported | |
CEILING | Supported | |
FLOOR | Supported | |
ROUND | With limitations | Rounds half to even; BigQuery rounds half away from zero, so results differ on exact .5 ties (ROUND(2.5) returns 2, not 3). |
TRUNC | Supported | |
MOD | Supported | |
DIV | Supported | Integer division. |
POW | Supported | |
POWER | Supported | |
SQRT | Supported | |
CBRT | Supported | |
EXP | Supported | |
LN | Supported | |
LOG | Supported | |
LOG10 | Supported | |
GREATEST | Supported | |
LEAST | Supported | |
RAND | Supported | |
SIN | Supported | |
COS | Supported | |
TAN | Supported | |
COT | Supported | |
ASIN | Supported | |
ACOS | Supported | |
ATAN | Supported | |
ATAN2 | Supported | |
CSC | Supported | Reciprocal of sine. |
SEC | Supported | Reciprocal of cosine. |
SAFE_DIVIDE | Supported | Returns NULL when the divisor is 0. |
SINH | Supported | |
COSH | Supported | |
TANH | Supported | |
ASINH | Supported | |
ACOSH | Supported | |
ATANH | Supported | |
COTH | Supported | |
CSCH | Supported | |
SECH | Supported | |
SAFE_ADD, SAFE_MULTIPLY, SAFE_NEGATE, SAFE_SUBTRACT | Not supported | |
IS_INF, IS_NAN, RANGE_BUCKET, COSINE_DISTANCE, EUCLIDEAN_DISTANCE | Not supported |
Functions
Math functions
BigQuery mathematical functions supported in BigQuery compatibility mode.