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 |