hive建表

create table person
(
id int,
name string,
hobbies array<string>,
address map<string,string>
)
partitioned by (spark_load_date STRING)        		分区字段
row format delimited
fields terminated by ','                     		字段之间分隔符
collection items terminated by '-'                  数组之间分隔符
map keys terminated by ':'                          map之间分隔符
STORED AS textfile;									建表类型