hive 复合类型字段的使用

row format参数

ROW FORMAT DELIMITED 
	[FIELDS TERMINATED BY char [ESCAPED BY char]] 
	[COLLECTION ITEMS TERMINATED BY char]
	[MAP KEYS TERMINATED BY char] 
	[LINES TERMINATED BY char]

参数	注释
FIELDS TERMINATED BY	指定字段分割符
COLLECTION ITEMS TERMINATED BY	指定复合类型字段中元素间的分割符
MAP KEYS TERMINATED BY	指定map类型字段中key:value的分割符
LINES TERMINATED BY	指定每条记录之间的分割符，默认为\n

array类型

create table if not exists array_table (
a array<string>, 
b array<string>
)
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t'
COLLECTION ITEMS TERMINATED BY ',';

load data local inpath 'filepath' [overwrite] into table array_table;

map类型

create table map_table (
a string , 
b map<string, string>
)
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t'
COLLECTION ITEMS TERMINATED BY ','
MAP KEYS TERMINATED BY ':'
STORED AS TEXTFILE;

load data local inpath 'filepath' [overwrite] into table map_table;

struct类型

create table struct_table(
a int, 
b struct<x:string, y:int>
) 
ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' 
COLLECTION ITEMS TERMINATED BY ':';

load data local inpath 'filepath' [overwrite] into table struct_table;