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”…