一 Array类型字段的插入与查询:
1创建表:
hive>create table message_array(id int,namearray array<STRING>) row format delimited fields terminated by "\t" collection items terminated by ':';
(其中表字段之间是 '\t '分隔,array表里是 ':' 分隔)
显示OK 这就表示此表建好了
2导入本地文件:
先把本地文件写好
导入 hive>load data local inpath './message_array.txt' into table message_array;
查询表:
hive>select namearray[0] from message_array where id=3;
以及select的很多操作
二 Struct
1创建表
hive>create table message_struct(id int,studentstruct struct<name:string,age:int>) row format delimited fields terminated by "\t" collection items terminated by ':';
2导入文件
hive>load data local inpath './message_struct.txt' into table message_struct;
3查询操作
select studentstruct.age from message_struct;
三 Map
1创建表
hive>create table message_map(id int,messagemap map<string,string>) row format delimited fields terminated by "\t" collection items terminated by ',' map keys terminated by ':';
2导入表
hive>load data local inpath './message_map.txt' into table message_map;
3查询表
hive>select messagemap['name'] from message_map where messagemap['work']='boss';