595      iPhone_iPad_Mac_手機_平板_蘋果apple

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-阿裏雲