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

Columns分区

建表语句如下:

CREATE TABLE employees(c1 int, c2 int, c3 int, c4 int, PRIMARY KEY (c1,c2)) engine=greatdb PARTITION BY LIST COLUMNS (c2) (PARTITION p1 VALUES IN (1,2), PARTITION p2 VALUES IN (3,4));

(1)、支持的操作

支持的操作有add partition/drop partition/analyze partition/truncate partition，例子参考Range分区部分。

(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.