Hive分区注意事项

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