"decisionResults": [ { "breakCondition": "REJECT", "costTime": 0, "treeId": 1023, "version": 1651744914000 }, { "breakCondition": "REJECT", "costTime": 4, "treeId": 1024, "version": 1659319737000 }, { "costTime": 1208, "name": "【BLAZE】司机贷授信事件决策", "result": "REJECT", "treeId": 1036, "version": 1636104372000 } ] 用hivesql 取出breakCondition这个字段的数据
时间: 2023-07-12 07:01:10 浏览: 219
await-timeout:基于Promise的API,用于setTimeout clearTimeout
可以使用以下HiveQL语句来提取"breakCondition"字段的数据:
```
SELECT decisionResults.breakCondition
FROM your_table_name
LATERAL VIEW explode(decisionResults) exploded_table AS decisionResults
```
其中,"your_table_name"是包含上述JSON数据的Hive表的名称。这个查询将返回一个包含所有"breakCondition"字段的结果集。
阅读全文