hive四种导入方式
建表语句
create table test( name string, friends array, children map<string, int>, address struct<street:string, city:string> ) row format delimited fields terminated by ‘,’ collection items terminated by ‘_’ map keys terminated by ‘:’ lines terminated by ‘\n’; row format delimited fields terminated by ‘,’ – 列分隔符 collection items terminated by ‘_’ --MAP STRUCT 和 ARRAY 的分隔符(数据分割符号) map keys terminated by ‘:’ – MAP中的key与value的分隔符 lines terminated by ‘\n’; – 行分隔符
1、数据在linux本地
row format delimited fields terminated by '|' lines terminated by '\n' stored as textfile; load data local inpath '/home/data/data7.txt' into table tab7;
2、数据在hdfs上
load data inpath '/home/xiong/add.txt' into table xiong;
3、将其他表查询出来的数据导入到表中
insert into table test
4、在创建表的时候,将其他表查询出来的数据导入到表中
insert into table test