OPAL Semistructured Functions

Function	Description
array	Convert a datum into an array or NULL if conversion…
array_agg	Returns an array of concatenated input values. The…
array_length	returns the number of elements in an array, or null…
array_null	Returns a null value of type array. This is importan…
drop_fields	Drop one or more fields from an object.
get_field	Given an object, and a computed string value as key…
get_item	Given an array, and a computed index, return the…
make_array	Returns an array constructed from zero, one or more…
make_fields	Extend an existing object with new fields.
make_object	Turn a sequence of name:value elements into an object.
match_regex	Return true if the argument input string or object…
match_regex_all	Returns an array containing all parts of the…
object	Convert a datum into an object or NULL if conversion…
object_agg	Returns one OBJECT per group. For each (key, value)…
object_keys	Get array of object keys (field names from object).
object_null	Returns a null value of type object. This is…
parse_csv	Parses an input string as character-separated…
parse_ip	When the input is an IPv(4/6) address, returns a…
parse_kvs	Returns an object of key=value pairs extracted from…
parse_url	Returns a JSON object consisting of all the componen…
path_exists	Given a column and path, return whether the JSON…
pick_fields	Pick one or more fields from an object.
pivot_array	Converts an array of “key”-“value” pairs into an…
slice_array	Given an array, returns a possibly smaller array,…
split	Splits the string into an array, based on the…
tokenize	Splits the string into an array based on separator,…
unpivot_array	Convert an object into an array of “key”-“value”…