---
url: /v6.2/en-us/calculation-function-json.md
---
# 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 |