# JSON Functions
JSON functions manipulate JSON string or return information about JSON. There are several json path manipulation functions. Please refer to json path functions for how to compose a json path.
# TO_JSON
to_json(col)
1
Converts a value to a string containing the JSON representation of the value. If the input is NULL, the result is also NULL.
# PARSE_JSON
parse_json(col)
1
Converts a JSON string to a value. If the input is NULL, the result is also NULL.
# JSON_PATH_EXISTS
json_path_exists(col, json_path)
1
Check whether JSON path returns any item for the specified JSON value. Return bool value.
# JSON_PATH_QUERY
json_path_query(col, json_path)
1
Get all items returned by JSON path for the specified JSON value.
# JSON_PATH_QUERY_FIRST
json_path_query_first(col, json_path)
1
Get the first item returned by JSON path for the specified JSON value.