数据类型

--数据展示
{
"name":"zhangshan",
"friends":["lisi","wangwu"],
"children":{
   "zhaoliu":18,
   "longqi":20
            },
"address":{
    "sreet":"hui long guan",
    "city":"beijing"
             }
}

--数据存储
zhangshan,lisi_wangwu,zhaoliu:18_longqi:20,hui long guan_beijing
zhoushan,wanngsi_zhuwu,hangliu:20_longwu:30,tian tong yuan_beijing

--创建表
create table if not exists kg_risk_person(
name string,
friends array<string>,
children map<string,int>,
address struct<sreet:string,city:string>)
row format delimited fields terminated by ","
collection items terminated by "_"
map keys terminated by ":"
lines terminated by "\n";

--上传数据
load data local inpath "/home/kg/qiaoruihua/hive/person.txt" into table kg_risk_person;

--查询数据
select name,friends[0],children["zhaoliu"],address.city from kg_risk_person where name="zhangshan";