Hive读取复杂的数据类型（Array，Map，Struct）

1.数组
数据文件 hive_array.txt,Array(1,2,3,4)  装的数据类型是一样的

zhnagsan        PEK,SHA,HAK,NKG
lisi    CTU,CKG,XIY,CSX

创建表：

create table hive_array(name string, work_locations array<string>)
row format delimited fields terminated by '\t'
COLLECTION ITEMS TERMINATED BY ',';

加载数据：load data local inpath '/home/hadoop/testdata/hive_array.txt' into table hive_array;
查询数据：

+------------------+----------------------------+--+
| hive_array.name  | hive_array.work_locations  |
+------------------+----------------------------+--+
| zhnagsan         | ["PEK","SHA","HAK","NKG"]  |
| lisi             | ["CTU","CKG","XIY","CSX"]  |
+------------------+----------------------------+--+
2 rows selected (0.