文法
ALTER TABLEGROUP tg_name alter_tablegroup_specification;
-- 對于Range分區,支援以下文法:
-- 将分區分裂成指定範圍的多個分區
ALTER TABLEGROUP tg_name split PARTITION identifier INTO
(partition_definition,partition_definition, [, partition_definition] ...);
partition_definition:
PARTITION partition_name
[VALUES
{LESS THAN {(value_list) | MAXVALUE}
|
IN (value_list)}]
-- 對于Range分區,支援以下文法
-- 按照指定值将一個range分區一分為二
ALTER TABLEGROUP tg_name split PARTITION partition_name at(number) into
(PARTITION partition_name,
PARTITION partition_name);
-- 對于List分區,支援以下文法:
ALTER TABLEGROUP tg_name split PARTITION partition_name into
(partition_definition,partition_definition, [, partition_definition] ...);
-- 對于Hash分區,支援以下文法:
-- 用分區均值作為分裂點,将一個分區切分為兩個分區
ALTER TABLEGROUP tg_name SPLIT PARTITION partition_name;
-- 将熱點值提取到單獨到分區
ALTER tablegroup tgName extract to partition by hot value(xxx)
- 分區合并将多個分區(兩個或者兩個以上)合并成一個分區。
ALTER TABLEGROUP tg_name MERGE PARTITIONS partition_name,...,partition_name TO partition_name;
e.g.
ALTER TABLEGROUP tbl_tg MERGE PARTITIONS p2,p3 to p23;
ALTER TABLEGROUP tg_name MOVE PARTITIONS partition_name,...,partition_name TO dn_id
e.g.
ALTER TABLEGROUP tg_name MOVE PARTITIONS p2,p4 to 'dn-0' ;
- 增加分區對于Range/List政策的分區組,支援增加分區。
ALTER TABLEGROUP tg_name add partition (partition_definition [,partition_definition] ...)
- 删除分區對于Range/List分區政策的分區組,支援删除分區。
ALTER TABLEGROUP tg_name drop partition partitiion_name [,partition_name] ...
ALTER TABLEGROUP tg_name rename partition partitiion_name to partitiion_name[, partitiion_name to partitiion_name]
- 修改分區值隻支援對list/list column分區政策的分區修改分區值。
ALTER TABLEGROUP tg_name modify partition_name add/drop values in (value_list)