JSON Functions
jsonget
Syntax | jsonget(JSON,KEY) |
---|---|
Parameters | 1. JSON type parameter, optional type: JSON; 2. Specified key, optional type: string |
Return Type | STRING |
Description | Retrieve the specified key from JSON |
Example | jsonget('{"name":"张三","age":20}', 'name'), returns: "张三" |
Unsupported Data Sources | impala, hive, spark, oracle, db2, mongodb, maxcompute |