Skip to content

JSON Functions

jsonget

Syntaxjsonget(JSON,KEY)
Parameters1. JSON type parameter, optional type: JSON;
2. Specified key, optional type: string
Return TypeSTRING
DescriptionRetrieve the specified key from JSON
Examplejsonget('{"name":"张三","age":20}', 'name'), returns: "张三"
Unsupported Data Sourcesimpala, hive, spark, oracle, db2, mongodb, maxcompute

User Manual for Hengshi Analysis Platform