【Hive】【内置常用函数】-CSDN博客

网站介绍:文章浏览阅读616次。get_json_object1)数据 json数组[{"name":"大郎","sex":"男","age":"25"},{"name":"西门庆","sex":"男","age":"47"}]2)取出第一个json对象select get_json_object('[{"name":"大郎","sex":"男","age":"25"},{"name":"西门庆","sex":"男","age":"47"}]','$[0]');结果是:{“name”:“大郎”,“sex”:“男”,“age