Mathematical Functions

function

math::abs()

math::abs(x: anyreal) -> anyreal

Return the absolute value of the input x.

db>

select math::abs(1);

{1}

db>

select math::abs(-1);

{1}

function

math::ceil()

math::ceil(x: int64) -> float64math::ceil(x: float64) -> float64math::ceil(x: bigint) -> bigintmath::ceil(x: decimal) -> decimal

Round up to the nearest integer.

db>

select math::ceil(1.1);

{2}

db>

select math::ceil(-1.1);

{-1}

function

math::floor()

math::floor(x: int64) -> float64math::floor(x: float64) -> float64math::floor(x: bigint) -> bigintmath::floor(x: decimal) -> decimal

Round down to the nearest integer.

db>

select math::floor(1.1);

{1}

db>

select math::floor(-1.1);

{-2}

function

math::ln()

math::ln(x: int64) -> float64math::ln(x: float64) -> float64math::ln(x: decimal) -> decimal

Return the natural logarithm of the input value.

db>

select 2.718281829 ^ math::ln(100);

{100.00000009164575}

function

math::lg()

math::lg(x: int64) -> float64math::lg(x: float64) -> float64math::lg(x: decimal) -> decimal

Return the base 10 logarithm of the input value.

db>

select 10 ^ math::lg(42);

{42.00000000000001}

function

math::log()

math::log(x: decimal, named only base: decimal) -> decimal

Return the logarithm of the input value in the specified base.

db>

select 3 ^ math::log(15n, base := 3n);

{15.0000000000000005n}

function

math::mean()

math::mean(vals: set of int64) -> float64math::mean(vals: set of float64) -> float64math::mean(vals: set of decimal) -> decimal

Return the arithmetic mean of the input set.

db>

select math::mean({1, 3, 5});

{3}

function

math::stddev()

math::stddev(vals: set of int64) -> float64math::stddev(vals: set of float64) -> float64math::stddev(vals: set of decimal) -> decimal

Return the sample standard deviation of the input set.

db>

select math::stddev({1, 3, 5});

{2}

function

math::stddev_pop()

math::stddev_pop(vals: set of int64) -> float64math::stddev_pop(vals: set of float64) -> float64math::stddev_pop(vals: set of decimal) -> decimal

Return the population standard deviation of the input set.

db>

select math::stddev_pop({1, 3, 5});

{1.63299316185545}

function

math::var()

math::var(vals: set of int64) -> float64math::var(vals: set of float64) -> float64math::var(vals: set of decimal) -> decimal

Return the sample variance of the input set.

db>

select math::var({1, 3, 5});

{4}

function

math::var_pop()

math::var_pop(vals: set of int64) -> float64math::var_pop(vals: set of float64) -> float64math::var_pop(vals: set of decimal) -> decimal

Return the population variance of the input set.

db>

select math::var_pop({1, 3, 5});

{2.66666666666667}