Presto查询hive字段为json类型的方法
针对样例数据做示例说明:
HIVE ->
-- employee表的xjson字段,只有一条数据
[{"name":"王二","sex":"男","age":"25"},{"name":"李四","sex":"男","age":"47"}]
select get_json_object(xjson,'$.[0].age') from employee limit 1;
...
原创
2019-08-29 18:16:46 ·
6271 阅读 ·
0 评论