— 1 创建分区表
create table username.test_par(
cust_no string
)partitioned by(province_code string comment "按网省分区" ,YM string comment "按年月分区")
row format delimited fields terminated by ',';
备注 该表中以province_code和ym作为分区
– 2 向分区表中插入数据
insert into username.test_par PARTITION(province_code&