Math Functions
abs
Supported Signatures
function abs $1($1) returns $1
where $1 in (bigint, float64)
acos
Supported Signatures
function acos $1($1) returns double
where $1 in (double, bigint)
acosh
Supported Signatures
function acosh $1($1) returns double
where $1 in (double, bigint)
asin
Supported Signatures
function asin $1($1) returns double
where $1 in (double, bigint)
asinh
Supported Signatures
function asinh $1($1) returns double
where $1 in (double, bigint)
atan
Supported Signatures
function atan $1($1) returns double
where $1 in (double, bigint)
atan2
Supported Signatures
function atan2 $1, $2($1, $2) returns double
where $1 in (bigint, double)
and $2 in (bigint, double)
atanh
Supported Signatures
function atanh $1($1) returns double
where $1 in (bigint, double)
cbrt
Supported Signatures
function cbrt $1($1) returns double
where $1 in (bigint, double)
ceil
Supported Signatures
function ceil(bigint) returns double
function ceil $1($1) returns $1
where $1 in (double)
ceiling
Supported Signatures
function ceiling(bigint) returns double
function ceiling $1($1) returns $1
where $1 in (double)
cos
Supported Signatures
function cos $1($1) returns double
where $1 in (bigint, double)
cosh
Supported Signatures
function cosh $1($1) returns double
where $1 in (bigint, double)
cot
Supported Signatures
function cot $1($1) returns double
where $1 in (bigint, double)
coth
Supported Signatures
function coth $1($1) returns double
where $1 in (bigint, double)
csc
Supported Signatures
function csc $1($1) returns double
where $1 in (bigint, double)
csch
Supported Signatures
function csch $1($1) returns double
where $1 in (bigint, double)
div
Supported Signatures
function div $1($1, $1) returns $1
where $1 in (bigint)
function div(bigint, decimal(p,s)) returns decimal(p,s)
function div(decimal(p,s), bigint) returns decimal(p,s)
function div(decimal(p,s), bigint) returns decimal(p,s)
function div(bigint, decimal(p,s)) returns decimal(p,s)
exp
Supported Signatures
function exp(bigint) returns double
function exp $1($1) returns $1
where $1 in (double)
floor
Supported Signatures
function floor $1($1) returns $1
where $1 in (double)
function floor(bigint) returns double
greatest
Supported Signatures
function greatest $1($1, ...) returns $1
where $1 in (bigint, double)
ieee_divide
Supported Signatures
function ieee_divide $1, $2($1, $2) returns double
where $1 in (bigint, double)
and $2 in (bigint, double)
is_inf
Supported Signatures
function is_inf $1($1) returns bool
where $1 in (bigint, double)
is_nan
Supported Signatures
function is_nan $1($1) returns bool
where $1 in (bigint, double)
least
Supported Signatures
function least $1($1, ...) returns $1
where $1 in (bigint, double)
ln
Supported Signatures
function ln(bigint) returns double
function ln $1($1) returns double
where $1 in (double)
log
Supported Signatures
function log(bigint) returns double
function log $1($1) returns double
where $1 in (double)
function log $1($1, $1) returns $1
where $1 in (double)
function log(bigint, bigint) returns double
function log(bigint, decimal(p,s)) returns decimal(p,s)
function log(decimal(p,s), bigint) returns decimal(p,s)
function log(decimal(p,s), bigint) returns decimal(p,s)
function log(bigint, decimal(p,s)) returns decimal(p,s)
function log(double, bigint) returns double
function log(bigint, double) returns double
function log(decimal(p,s), double) returns double
function log(double, decimal(p,s)) returns double
function log(double, decimal(p,s)) returns double
function log(decimal(p,s), double) returns double
log10
Supported Signatures
function log10(bigint) returns double
function log10 $1($1) returns $1
where $1 in (double)
mod
Supported Signatures
function mod $1($1, $1) returns $1
where $1 in (bigint)
function mod(bigint, decimal(p,s)) returns decimal(p,s)
function mod(decimal(p,s), bigint) returns decimal(p,s)
function mod(decimal(p,s), bigint) returns decimal(p,s)
function mod(bigint, decimal(p,s)) returns decimal(p,s)
pow
Supported Signatures
function pow $1($1, $1) returns $1
where $1 in (double)
function pow(bigint, bigint) returns double
function pow(bigint, decimal(p,s)) returns decimal(p,s)
function pow(decimal(p,s), bigint) returns decimal(p,s)
function pow(decimal(p,s), bigint) returns decimal(p,s)
function pow(bigint, decimal(p,s)) returns decimal(p,s)
function pow(double, bigint) returns double
function pow(bigint, double) returns double
function pow(double, decimal(p,s)) returns double
function pow(decimal(p,s), double) returns double
function pow(double, decimal(p,s)) returns double
function pow(decimal(p,s), double) returns double
power
Supported Signatures
function power $1($1, $1) returns $1
where $1 in (double)
function power(bigint, bigint) returns double
function power(bigint, decimal(p,s)) returns decimal(p,s)
function power(decimal(p,s), bigint) returns decimal(p,s)
function power(decimal(p,s), bigint) returns decimal(p,s)
function power(bigint, decimal(p,s)) returns decimal(p,s)
function power(double, bigint) returns double
function power(bigint, double) returns double
function power(double, decimal(p,s)) returns double
function power(decimal(p,s), double) returns double
function power(double, decimal(p,s)) returns double
function power(decimal(p,s), double) returns double
rand
Supported Signatures
function rand() returns double
range_bucket
Supported Signatures
function range_bucket($1, array<$1>) returns int64
round
Supported Signatures
function round(bigint) returns double
function round $1($1) returns $1
where $1 in (double)
function round(bigint, bigint) returns double
function round $1($1, bigint) returns $1
where $1 in (double)
function round(bigint, bigint, rounding_mode string) returns double
where rounding_mode in (round_half_even, round_half_away_from_zero)
function round $1($1, bigint, rounding_mode string) returns $1
where rounding_mode in (round_half_even, round_half_away_from_zero)
where $1 in (double)
safe_add
Supported Signatures
function safe_add $1($1, $1) returns $1
where $1 in (bigint, double)
function safe_add(bigint, decimal(p,s)) returns decimal(p,s)
function safe_add(decimal(p,s), bigint) returns decimal(p,s)
function safe_add(decimal(p,s), bigint) returns decimal(p,s)
function safe_add(bigint, decimal(p,s)) returns decimal(p,s)
function safe_add(double, bigint) returns double
function safe_add(bigint, double) returns double
function safe_add(double, decimal(p,s)) returns double
function safe_add(decimal(p,s), double) returns double
function safe_add(double, decimal(p,s)) returns double
function safe_add(decimal(p,s), double) returns double
safe_divide
Supported Signatures
function safe_divide $1($1, $1) returns double
where $1 in (bigint, double)
function safe_divide(bigint, decimal(p,s)) returns decimal(p,s)
function safe_divide(decimal(p,s), bigint) returns decimal(p,s)
function safe_divide(decimal(p,s), bigint) returns decimal(p,s)
function safe_divide(bigint, decimal(p,s)) returns decimal(p,s)
function safe_divide(double, bigint) returns double
function safe_divide(bigint, double) returns double
function safe_divide(double, decimal(p,s)) returns double
function safe_divide(decimal(p,s), double) returns double
function safe_divide(double, decimal(p,s)) returns double
function safe_divide(decimal(p,s), double) returns double
safe_multiply
Supported Signatures
function safe_multiply $1($1, $1) returns $1
where $1 in (bigint, double)
function safe_multiply(bigint, decimal(p,s)) returns decimal(p,s)
function safe_multiply(decimal(p,s), bigint) returns decimal(p,s)
function safe_multiply(decimal(p,s), bigint) returns decimal(p,s)
function safe_multiply(bigint, decimal(p,s)) returns decimal(p,s)
function safe_multiply(double, bigint) returns double
function safe_multiply(bigint, double) returns double
function safe_multiply(double, decimal(p,s)) returns double
function safe_multiply(decimal(p,s), double) returns double
function safe_multiply(double, decimal(p,s)) returns double
function safe_multiply(decimal(p,s), double) returns double
safe_negate
Supported Signatures
function safe_negate $1($1) returns $1
where $1 in (bigint, double)
safe_subtract
Supported Signatures
function safe_subtract $1($1, $1) returns $1
where $1 in (bigint, double)
function safe_subtract(bigint, decimal(p,s)) returns decimal(p,s)
function safe_subtract(decimal(p,s), bigint) returns decimal(p,s)
function safe_subtract(decimal(p,s), bigint) returns decimal(p,s)
function safe_subtract(bigint, decimal(p,s)) returns decimal(p,s)
function safe_subtract(double, bigint) returns double
function safe_subtract(bigint, double) returns double
function safe_subtract(double, decimal(p,s)) returns double
function safe_subtract(decimal(p,s), double) returns double
function safe_subtract(double, decimal(p,s)) returns double
function safe_subtract(decimal(p,s), double) returns double
sec
Supported Signatures
function sec $1($1) returns double
where $1 in (bigint, double)
sech
Supported Signatures
function sech $1($1) returns double
where $1 in (bigint, double)
sign
Supported Signatures
function sign $1($1) returns $1
where $1 in (bigint, double)
sin
Supported Signatures
function sin $1($1) returns double
where $1 in (bigint, double)
sinh
Supported Signatures
function sinh $1($1) returns double
where $1 in (bigint, double)
sqrt
Supported Signatures
function sqrt(bigint) returns double
function sqrt $1($1) returns $1
where $1 in (double)
tan
Supported Signatures
function tan $1($1) returns double
where $1 in (bigint, double)
tanh
Supported Signatures
function tanh $1($1) returns double
where $1 in (bigint, double)
trunc
Supported Signatures
function trunc(bigint) returns double
function trunc $1($1) returns $1
where $1 in (double)
function trunc(bigint, bigint) returns double
function trunc $1($1, bigint) returns $1
where $1 in (double)