【文件属性】：
文件名称：hive解析json格式数据所需jar包
文件大小：73KB
文件格式：JAR
更新时间：2018-05-25 04:52:14
hive json
hive解析json时所需jar包。具体使用：
add jar ../../../target/json-serde-1.3-jar-with-dependencies.jar;
CREATE TABLE json_nested_test (
country string,
languages array,
religions map>)
ROW FORMAT SERDE 'org.openx.data.jsonserde.JsonSerDe'
STORED AS TEXTFILE;
-- data : {"country":"Switzerland","languages":["German","French",
-- "Italian"],"religions":{"catholic":[10,20],"protestant":[40,50]}}
LOAD DATA LOCAL INPATH 'nesteddata.txt' OVERWRITE INTO TABLE json_nested_test ;
select * from json_nested_test; -- result: Switzerland ["German","French","Italian"] {"catholic":[10,20],"protestant":[40,50]}
select languages[0] from json_nested_test; -- result: German
select religions['catholic'][0] from json_nested_test; -- result: 10
原下载地址：https://github.com/rcongiu/Hive-JSON-Serde
