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

子分区

建表语句如下:

create table employees (c1 int primary key, c2 int) engine=greatdb partition by range(c1) subpartition by hash (c1) subpartitions 2 (partition p0 values less than (100) (subpartition s0, subpartition s1), partition p1 values less than (200) (subpartition s2, subpartition s3));

(1)、支持的操作

支持的操作有add partition/add subpartition/drop partition/drop subpartition（通过drop主分区级联删除归属的子分区）/analyze partition/truncate partition.

(2)、不支持的操作

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