创建单分区:
create table day_table(id int, content string)
partitioned by (dt string)
创建多分区:
create table bigdata_jr.e_hb_zk (rysecret string, dt 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')