[root@node1 hive-1.2.1]# vi person.txt
zhangsan beijing,shanghai,tianjin,hangzhou
lisi changchu,chengdu,wuhan
0: jdbc:hive2://192.168.230.10:10000> load data local inpath '/opt/modules/hive-1.2.1/person.txt'
OVERWRITE INTO TABLE person;
1.3、查询person表
1.4、查询person表中array数据类型字段的指定列
0: jdbc:hive2://192.168.230.10:10000> select name,worklocations[0] from person;
0: jdbc:hive2://192.168.230.10:10000> select name,worklocations[3] from person;
0: jdbc:hive2://192.168.230.10:10000> select name,worklocations[2] from person;
0: jdbc:hive2://192.168.230.10:10000> select name,worklocations[1] from person;
1.5、查询array数据类型字段的长度
0: jdbc:hive2://192.168.230.10:10000> select name,size(worklocations) from person;
1.6、查询包含array数据类型字段指定列的一行数据
0: jdbc:hive2://192.168.230.10:10000> select * from person where array_contains(worklocations,"beijing");