Mathematical Functions

function

math::abs()

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

Return the absolute value of the input x.

1. db>

1. select math::abs(1);

1. {1}

1. db>

1. select math::abs(-1);

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.

1. db>

1. select math::ceil(1.1);

1. {2}

1. db>

1. select math::ceil(-1.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.

1. db>

1. select math::floor(1.1);

1. {1}

1. db>

1. select math::floor(-1.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.

1. db>

1. select 2.718281829 ^ math::ln(100);

1. {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.

1. db>

1. select 10 ^ math::lg(42);

1. {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.

1. db>

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

1. {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.

1. db>

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

1. {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.

1. db>

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

1. {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.

1. db>

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

1. {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.

1. db>

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

1. {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.

1. db>

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

1. {2.66666666666667}