hive从json行中选择一个特定的字符串

bq9c1y66 于 2021-06-26 发布在 Hive

关注(0)|答案(1)|浏览(341)

我正在尝试分析athena中的aws云跟踪日志，如果我选择security group add inbound rules event，它将在elements列中返回下面的字符串。

{"groupId":"sg-XXXX","ipPermissions":{"items":[{"ipProtocol":"tcp","fromPort":22,"toPort":22,"groups":{},"ipRanges":{"items":[{"cidrIp":"0.0.0.0/0"}]},"prefixListIds":{}}]}}

但我需要 groupId 唯一的结果。那我怎么才能得到呢？
注意：表是一个外部表

Hive JSON amazon-web-services amazon-athena

来源：https://stackoverflow.com/questions/42877874/hive-select-a-particular-string-from-a-json-row

1条答案

按热度按时间

42fyovps1#

select json_extract_scalar('{"groupId":"sg-XXXX","ipPermissions":{"items":[{"ipProtocol":"tcp","fromPort":22,"toPort":22,"groups":{},"ipRanges":{"items":[{"cidrIp":"0.0.0.0/0"}]},"prefixListIds":{}}]}}','$.groupId');
OK
sg-XXXX

赞(0）回复(0）举报 2021-06-26

我来回答

hive从json行中选择一个特定的字符串

1条答案

相关问题

热门标签

最新问答