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;