万里数据库分布式GreatDB Cluster基本功能-分区表（5）

Key分区

建表语句如下:

create table employees (c1 int primary key, c2 varchar(50)) engine = greatdb partition by key(c1) partitions 2 (partition p1, partition p2);

(1)、支持的操作

支持的操作有analyze partition/truncate partition。

(2)、不支持的操作

不支持的操作有add partition/drop partition/coalesce partition/reorganize partition/alter partition/admin partition/reorganize partition/rebuild partition/all partition/remove partition/exchange partition/check partition/repair partition/optimize partition.