ποΈ Arrow function
Queries an element that can be located by the json_path expression in a JSON object and returns a JSON value.
ποΈ cast
Converts a value between the JSON type and SQL type.
ποΈ get_json_bool
Parses and gets the boolean value from a specified JSON path in a JSON string.
ποΈ get_json_double
Extracts a floating-point value from a JSON string at the specified path.
ποΈ get_json_int
Extracts an integer value from a JSON string at the specified path.
ποΈ get_json_string,get_json_object
Analyzes and gets strings from the specified path (json_path) in a JSON string.
ποΈ json_contains
Checks whether a JSON document contains a specific value or subdocument.
ποΈ json_each
Expands the outermost elements of a JSON object into a set of key-value pairs held in two columns and returns a table that consists of one row for each element.
ποΈ json_exists
Checks whether a JSON object contains an element that can be located by the json_path expression.
ποΈ json_keys
Returns the top-level keys from a JSON object as a JSON array, or, if a path is specified, the top-level keys from the path.
ποΈ json_length
Returns the length of a JSON document.
ποΈ json_pretty
Formats a JSON document into an easy-to-read, indented string format.
ποΈ json_query
Queries the value of an element that can be located by the json_path expression in a JSON object and returns a JSON value.
ποΈ json_remove
Removes data from a JSON document at one or more specified JSON paths and returns the modified JSON document.
ποΈ json_set
Inserts or updates data in a JSON document at one or more specified JSON paths and returns the modified JSON document.
ποΈ json_string
Converting JSON object to JSON string
ποΈ to_json
Converts a Map or Struct value into a JSON string.
