hive array基本操作：建表+查询+修改

数据准备

# cat /root/person.txt 
zhangsan        beijing,shanghai,tianjin,hangzhou
lisi    changchu,chengdu,wuhan

创建表

Create table users(name string, worklocations array<string> ) row format delimited fields terminated by '\t' collection items terminated by ','; 

导入数据

load data local inpath '/root/person.txt ' OVERWRITE INTO TABLE<