金仓分区表使用

准备列表分区

CREATE TABLE TAB_LB (

    c1 INT,

    c2 CHAR(10),

    c3 DATE

)

PARTITION BY RANGE (c3);

CREATE TABLE "TAB_LB_P1" PARTITION OF TAB_LB FOR VALUES FROM (MINVALUE) TO ('2012-3-1');

CREATE TABLE "TAB_LB_P2" PARTITION OF TAB_LB FOR VALUES FROM ('2012-3-1') TO ('2012-5-1');

CREATE TABLE "TAB_LB_P3" PARTITION OF TAB_LB FOR VALUES FROM ('2012-5-1') TO ('2012-7-1');

1、查看分区

\d+ TAB_LB

2、添加分区

CREATE TABLE TAB_LB_P4 PARTITION OF TAB_LB FOR VALUES FROM ('2012-7-1') TO ('2012-9-1');

3、删除分区

drop table TAB_LB_P4;

4、截断分区

Truncate table TAB_LB_P2;

5、重命名分区

alter table tab_lb_p3 rename TO tab_lb_p3_new;