OPAL Misc Functions

Miscellaneous functions are those that do not fit in the other categories.

Function	Description
asc	Specify the ordering as ascending when processing data.
coalesce	Return the first non-null argument or null if all are null.
desc	Specify the ordering as descending when processing data.
float64	Generate a float representation of the argument value.
frame	Specify the approximate relative time frame for a window context.
frame_exact	Specify the exact relative time frame for a window context.
frame_following	Specifies a cumulative time frame for a window context, where the frame is the current row through the end of the query frame.
frame_preceding	Specifies a cumulative time frame for a window context, where the frame is all the rows from the beginning of the current query
hash	Accepts a variable number of arguments of arbitrary types and returns a signed 64-bit hash of the values.
if	Test if a condition is true or false.
if_null	Return the second argument if the first argument has the null value.
int64	Generate an integer representation of the argument value.
m_tdigest	Select a metric of type tdigest for the align verb.
nullsfirst	Specify the ordering as nulls first when processing data.
nullslast	Specify the ordering as nulls last when processing data.
numeric_null	Returns a null value of type numeric.
on	on is a special function used to specify the join condition for some join verbs.
order_by	Specify the ordering when processing data.
parse_hex	Parses a string encoded hex number and returns an int64.
strlen	Compute the length of an input string.
tdigest	Convert a JSON string, an object, or a variant to tdigest, if possible.
tdigest_null	Returns a null value of type tdigest.
variant_null	Returns a null value of type variant.