Hive表分区操作

it2023-12-19  58

创建单分区:

create table day_table(id int, content string) partitioned by (dt string) row format delimited fields terminated by ','

创建多分区:

create table bigdata_jr.e_hb_zk (rysecret string) partitioned by (dt string, rule string) row format delimited fields terminated by ','

注意:在创建 删除多分区等操作时一定要注意分区的先后顺序,他们是父子节点的关系。分区字段不要和表字段相同。

添加分区:

alter table day_hour_table add partition (dt='20201021', hour='07');

删除分区:

alter table day_hour_table drop partition (dt='20201021', hour='07'); alter table siebel_member drop if exists partition(dt='20180401'), partition(dt='20180402'), partition(dt='20180403'), partition(dt='20180404');

数据加载进分区:

load data local inpath '/test/phone.txt' into table day_hour_table partition (dt='20201021', hour='15')

查看分区:

show partitions day_hour_table;

重命名分区:

alter table day_hour_table partition(dt='20201022',hour='14') rename to partition(dt='20201023',hour='')17

 

 

最新回复(0)