Apache Tajo - JSON Functions

The JSON functions are listed in the following table −

S.No. Function & Description
1 json_extract_path_text(js on text, json_path text)

Extracts JSON string from a JSON string based on json path specified.

2 json_array_get(json_array text, index int4)

Returns the element at the specified index into the JSON array.

3 json_array_contains(json_ array text, value any)

Determine if the given value exists in the JSON array.

4 json_array_length(json_ar ray text)

Returns the length of json array.

Kickstart Your Career

Get certified by completing the course

Get Started