595      阿里云

key分区__分区_SQL语法参考_云数据库 OceanBase-阿里云

语法

...
PARTITION BY KEY（column_list）
 PARTITIONS num

KEY 分区只采用一个或多个列名的一个列表，它是按系统内部的哈希函数实现分区。

举例

创建表k1, 按id字段进行key分区。

Oceanbase> create table k2(id int primary key, name varchar(20)) partition by key() partitions 2;
Query OK, 0 rows affected (0.78 sec)

Oceanbase>show create table k2;
+-------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table                                                                                                                                                                                                                 |
+-------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| k2    | CREATE TABLE `k2` (
  `id` int(11) NOT NULL,
  `name` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) DEFAULT CHARSET = utf8mb4 REPLICA_NUM = 3 BLOCK_SIZE = 16384 USE_BLOOM_FILTER = FALSE partition by key() partitions 2 |
+-------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.03 sec)

此例中，id是主键字段，partition by key()和partition by key(id)是等效的。

最后更新：2016-11-24 11:23:47

  上一篇： hash分区__分区_SQL语法参考_云数据库 OceanBase-阿里云

  下一篇： 子分区__分区_SQL语法参考_云数据库 OceanBase-阿里云