OPAL Misc Functions

Function

Description

any_null

Returns a null value of type any. This is important,…

coalesce

Return the first non-null argument or null if all…

frame

Specify the relative time frame for a window…

frame_exact

Specify the relative time frame for a window…

if

Return the second argument if condition# is true,…

if_null

Return the second argument if the first argument has…

in

Returns true if the expression matches with any…

order_by

Specify the ordering when processing data. This is…

parse_json

Parse the argument value as a JSON string.

position

Searches for the first occurrence of the second…

string

Generate a string representation of the argument…

string_null

Returns a null value of type string. This is…