json_extract_path_text()
Advertisements
Let us now check the json_extract_path_text(json text, json_path text) function with the following query.
Query
default> select json_extract_path_text('{"tutorial" : {"key" : "tajo"}}','$.tutorial.key') as path;
Result
The above query will generate the following result.
path ------------------------------- tajo
The query extracts the JSON string “tutorial” from a JSON string based on the JSON path.
apache_tajo_json_functions.htm
Advertisements