| create table ptestfilter_n0 (a string, b int) partitioned by (c int, d int); |
| describe ptestfilter_n0; |
| |
| alter table ptestfilter_n0 add partition (c=1, d=1); |
| alter table ptestfilter_n0 add partition (c=1, d=2); |
| alter table ptestFilter_n0 add partition (c=2, d=1); |
| alter table ptestfilter_n0 add partition (c=2, d=2); |
| alter table ptestfilter_n0 add partition (c=3, d=1); |
| alter table ptestfilter_n0 add partition (c=30, d=2); |
| show partitions ptestfilter_n0; |
| |
| alter table ptestfilter_n0 drop partition (c=1, d=1); |
| show partitions ptestfilter_n0; |
| |
| alter table ptestfilter_n0 drop partition (c=2); |
| show partitions ptestfilter_n0; |
| |
| alter table ptestfilter_n0 drop partition (c<4); |
| show partitions ptestfilter_n0; |
| |
| drop table ptestfilter_n0; |
| |
| |