Hive分区更方便于数据管理,常见的有时间分区和业务分区。
show partitions 表名; --展示表分区
--创建单分区表
create table t1(
id int
,name string
,hobby array<string>
,add map<String,string>
)
partitioned by (pt_d string)
row format delimited
fields terminated by ','
collection items terminated by '-'
map keys terminated by ':';
注:这里分区字段不能和表中的字段重复。
如果分区字段和表中字段相同的话,会报错,如下:
create table t1(
id int
,name string
,hobby array<string>
,add map<String,string>
)
partitioned by (id int)
row format delimited
fields terminated by ','
collection items terminated by '-'
map keys terminated by ':';
报错信息:FAILED: SemanticException [Error 10035]: Column repeated in partitioning columns