OPAL Numeric Functions

Function

Description

abs

Returns the absolute value of ‘val’.

array_length

returns the number of elements in an array, or null…

avg

Calculate the arithmetic average of the input…

ceil

Returns ‘val’ rounded up to the given ‘precision’….

count

Count the number of non-null items in the group.

count_distinct

Estimate the approximate number of distinct values…

count_distinct_exact

Count the exact number of distinct values in the…

dense_rank

Returns the dense rank within an ordered group of…

deriv

Calculate the average per-second derivative of the…

exp

Returns Euler’s number e raised to the given number.

float64

Generate a float representation of the argument value.

float64_null

Returns a null value of type float64. This is…

floor

Returns ‘val’ rounded down to the given ‘precision’….

hash

Accepts a variable number of arguments of arbitrary…

haversine_distance_km

Computes the great circle approximate distance…

int64

Generate a int representation of the argument value….

int64_null

Returns a null value of type int64. This is importan…

ln

Returns natural logarithm of a numeric expression….

log

Returns logarithm of a numeric expression (second…

median

Return the fast approximate median value of one…

mod

Returns the the remainder when dividend is divided…

numeric_null

Returns a null value of type numeric. This is…

parse_hex

Parses a string encoded hex number and returns an…

percentile

Returns an approximated value for the specified…

percentile_cont

Assuming a continuous distribution, it returns the…

percentile_disc

Assuming a discrete distribution, it returns the…

pow

Returns a number ‘base’ raised to the specified…

rank

Returns the rank within an ordered group of values….

rate

Calculate the average per-second rate of the…

round

Returns ‘val’ rounded to the given ‘precision’….

row_number

Return the window index of the row within its…

sqrt

Returns the square root for a given input and null…

stddev

Calculate the standard deviation across the group.

strlen

Compute the length of an input string.