hive四种导入方式

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