hive处理json数据

最新推荐文章于 2022-12-18 10:45:51 发布

Kuso_0814

最新推荐文章于 2022-12-18 10:45:51 发布

阅读量623

点赞数

本文链接：https://blog.csdn.net/Kuso_0814/article/details/81670080

版权

本文介绍了如何在Hive中利用get_json_object函数处理JSON格式的数据。通过创建表并导入JSON数据，然后解析指定字段如'movie', 'rate', 'timeStamp'和'uid'，并将解析结果存储到新的表中，实现对JSON数据的有效操作。" 82826885,634897,DllMain死锁原因深入剖析,"['c++', 'Windows编程', '死锁分析', 'DLL开发', '系统内核']

摘要由CSDN通过智能技术生成

今天练习一下在hive中使用get_json_object这个函数，首先创建一个表将json格式的数据导入

create table json01(line string);

将数据导入:

load data local inpath '/home/hadoop/json_test' into table json01;

导入数据如下：

{"movie":"1193","rate":"5","timeStamp":"978300760","uid":"1"}
{"movie":"661","rate":"3","timeStamp":"978302109","uid":"1"}
{"movie":"914","rate":"3","timeStamp":"978301968","uid":"1"}
{"movie":"3408","rate":"4","timeStamp":"978300275","uid":"1"}
{"movie":"2355","rate":"5","timeStamp":"978824291","uid":"1"}
{"movie":"1197","rate":"3","timeStamp":"978302268","uid":"1"}
{"movie":"1287","rate":"5","