hive如何获取{ "CustomCell": [{ "enName": "Name", "cnName": "企业名称" }, { "enName": "OperName", "cnName": "法定代表人" }, { "enName": "StartDate", "cnName": "成立日期" }, { "enName": "Address", "cnName": "企业注册地址" }, { "enName": "PhoneNumber", "cnName": "电话" }, { "enName": "MoreTelList", "cnName": "更多电话" }, { "enName": "InsuredCount", "cnName": "参保人数" }, { "enName": "Scope", "cnName": "经营范围" }] }里的cnname
时间: 2023-04-03 20:00:48 浏览: 55
可以使用Hive中的json_tuple函数来获取{ "CustomCell": [{ "enName": "Name", "cnName": "企业名称" }, { "enName": "OperName", "cnName": "法定代表人" }, { "enName": "StartDate", "cnName": "成立日期" }, { "enName": "Address", "cnName": "企业注册地址" }, { "enName": "PhoneNumber", "cnName": "电话" }, { "enName": "MoreTelList", "cnName": "更多电话" }, { "enName": "InsuredCount", "cnName": "参保人数" }, { "enName": "Scope", "cnName": "经营范围" }] }中的cnname。具体的语法为:json_tuple(json_string, key1, key2, ...),其中json_string为json格式的字符串,key1、key2等为需要获取的键名。因此,可以使用以下语句来获取cnname:
SELECT json_tuple('{"CustomCell":[{"enName":"Name","cnName":"企业名称"},{"enName":"OperName","cnName":"法定代表人"},{"enName":"StartDate","cnName":"成立日期"},{"enName":"Address","cnName":"企业注册地址"},{"enName":"PhoneNumber","cnName":"电话"},{"enName":"MoreTelList","cnName":"更多电话"},{"enName":"InsuredCount","cnName":"参保人数"},{"enName":"Scope","cnName":"经营范围"}]}', 'CustomCell', '', 'cnName');
相关推荐
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)