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.