Scalar FunctionsDynamic / JSON Functions
extract_dynamic
Extract a value from a dynamic value using a JSONPath expression.
Syntax
extract_dynamic(path, source)Parameters
Prop
Type
Returns: dynamic
Examples
Example 1
print extract_json("$.warrior", dynamic({"warrior":"Ragnar", "weapon":"axe"}))| print_0 (dynamic) |
|---|
| "Ragnar" |
column_ifexists
If a column named `column_name` exists in the current row set, return its value for the current row; otherwise evaluate and return `default`. Resolved at query compile time, so the column name must be a constant string and the default's type is ignored when the column exists.
extract_json
Extract a value from a JSON string using a JSONPath expression.