<\/span><\/h2>\n\n\n\n_t_gcluster_reorganize_partition_enable<\/code><\/pre>\n\n\n\n\u8be5\u53c2\u6570\u4ee5\u4e0b\u5212\u7ebf\u5f00\u59cb\uff0c\u4e0d\u4fdd\u8bc1\u540e\u7eed\u8be5\u53c2\u6570\u4f9d\u7136\u5b58\u5728\u6216\u8005\u540d\u5b57\u4e0d\u4f1a\u6709\u53d8\u5316\u3002<\/p>\n\n\n\n
\u9ed8\u8ba4\u503c0\uff0c\u4e0d\u652f\u6301\u5206\u533a\u91cd\u7ec4\u3002 1\uff1a\u5f00\u542f\u5206\u533a\u91cd\u7ec4\u529f\u80fd<\/p>\n\n\n\n
\u652f\u6301session\u7ea7\u8bbe\u7f6e<\/p>\n\n\n\n
<\/span>\u73af\u5883<\/span><\/h2>\n\n\n\n<\/span>\u96c6\u7fa4\u7248\u672c<\/span><\/h3>\n\n\n\n9.5.3.27.14 \u96c6\u7fa4<\/p>\n\n\n\n
<\/span>\u5206\u533a\u8868<\/span><\/h3>\n\n\n\ncreate table t_p(a int, b varchar(10))\r\npartition by range(a)(\r\n partition p0 values less than(10),\r\n partition p1 values less than(20),\r\n partition p2 values less than(30),\r\n partition p3 values less than(40),\r\n partition p4 values less than(50)\r\n); \r\n\r\ninsert into t_p values(1,1111),(10,101010),(15,151515),(20,202020),(25,252525),(30,303030),(40,404040);\r\nselect * from t_p partition (p0);\r\nselect * from t_p partition (p1);\r\nselect * from t_p partition (p2);\r\nselect * from t_p partition (p3);\r\nselect * from t_p partition (p4);<\/code><\/pre>\n\n\n\n\u6267\u884c\u6548\u679c\uff0c\u8bf7\u91cd\u70b9\u5173\u6ce8p2(2\u884c)\u548cp3(1\u884c)\u5206\u533a\uff0c\u540e\u9762\u5c06\u4ee5\u5176\u4e3a\u4f8b\u5b50\u8fdb\u884c\u5408\u5e76\u548c\u62c6\u5206\u3002<\/p>\n\n\n\n
gbase> create table t_p(a int, b varchar(10))\r\n -> partition by range(a)(\r\n -> partition p0 values less than(10),\r\n -> partition p1 values less than(20),\r\n -> partition p2 values less than(30),\r\n -> partition p3 values less than(40),\r\n -> partition p4 values less than(50)\r\n -> );\r\nQuery OK, 0 rows affected (Elapsed: 00:00:00.41)\r\n\r\ngbase>\r\ngbase> insert into t_p values(1,1111),(10,101010),(15,151515),(20,202020),(25,252525),(30,303030),(40,404040);\r\nQuery OK, 7 rows affected (Elapsed: 00:00:00.32)\r\nRecords: 7 Duplicates: 0 Warnings: 0\r\n\r\ngbase> select * from t_p partition (p0);\r\n+------+------+\r\n| a | b |\r\n+------+------+\r\n| 1 | 1111 |\r\n+------+------+\r\n1 row in set (Elapsed: 00:00:00.03)\r\n\r\ngbase> select * from t_p partition (p1);\r\n+------+--------+\r\n| a | b |\r\n+------+--------+\r\n| 10 | 101010 |\r\n| 15 | 151515 |\r\n+------+--------+\r\n2 rows in set (Elapsed: 00:00:00.00)\r\n\r\ngbase> select * from t_p partition (p2);\r\n+------+--------+\r\n| a | b |\r\n+------+--------+\r\n| 20 | 202020 |\r\n| 25 | 252525 |\r\n+------+--------+\r\n2 rows in set (Elapsed: 00:00:00.02)\r\n\r\ngbase> select * from t_p partition (p3);\r\n+------+--------+\r\n| a | b |\r\n+------+--------+\r\n| 30 | 303030 |\r\n+------+--------+\r\n1 row in set (Elapsed: 00:00:00.00)<\/span>\r\n\r\ngbase> select * from t_p partition (p4);\r\n+------+--------+\r\n| a | b |\r\n+------+--------+\r\n| 40 | 404040 |\r\n+------+--------+\r\n1 row in set (Elapsed: 00:00:00.00)<\/code><\/pre>\n\n\n\n<\/span>\u4fee\u6539\u53c2\u6570\u5f00\u542f\u529f\u80fd<\/span><\/h2>\n\n\n\ngbase> show variables like '%partition%';\r\n+----------------------------------------------------+-------+\r\n| Variable_name | Value |\r\n+----------------------------------------------------+-------+\r\n| _t_gcluster_hash_redist_on_multiple_olap_partition | 0 |\r\n| _t_gcluster_reorganize_partition_enable | 0 |\r\n| have_partitioning | YES |\r\n+----------------------------------------------------+-------+\r\n3 rows in set (Elapsed: 00:00:00.00)\r\n\r\ngbase> set _t_gcluster_reorganize_partition_enable=1;\r\nQuery OK, 0 rows affected (Elapsed: 00:00:00.00)<\/code><\/pre>\n\n\n\n<\/span>\u5408\u5e76\u5206\u533a<\/span><\/h2>\n\n\n\n\u628a\u5206\u533ap2\u4e0ep3\u5408\u5e76\u4e3ap3\u5206\u533a\u3002\u6b64\u5904\u65e0\u9700\u7ea0\u7ed3\u5206\u533a\u540d\u5b57\uff0c\u53ebp3_new\u7b49\u6ca1\u533a\u522b\uff0c\u53ea\u8981\u5408\u5e76\u540e\u7684\u8868\u5206\u533a\u540d\u5b57\u4e0d\u91cd\u590d\u5373\u53ef\u3002<\/p>\n\n\n\n
\u4ece\u6267\u884c\u7ed3\u679c\u770b\uff0cp2\u5206\u533a\u6d88\u5931\uff0c\u65b0\u7684p3\u5206\u533a\u5305\u542b\u4e86\u539f\u6709p2\u548cp3\u7684\u6570\u636e\uff082+1=3\u884c)\u3002<\/p>\n\n\n\n
gbase> alter table t_p reorganize partition p2,p3 into(partition p3 values less than(40));\nQuery OK, 0 rows affected (Elapsed: 00:00:00.66)\n\ngbase> show create table t_p;\n+-------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+\n| Table | Create Table |\n+-------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+\n| t_p | CREATE TABLE \"t_p\" (\n \"a\" int(11) DEFAULT NULL,\n \"b\" varchar(10) DEFAULT NULL\n) ENGINE=EXPRESS DEFAULT CHARSET=utf8 TABLESPACE='sys_tablespace'\n PARTITION BY RANGE (a)\n(PARTITION p0 VALUES LESS THAN (10) TABLESPACE = 'sys_tablespace' ENGINE = EXPRESS,\n PARTITION p1 VALUES LESS THAN (20) TABLESPACE = 'sys_tablespace' ENGINE = EXPRESS,\n PARTITION p3 VALUES LESS THAN (40) TABLESPACE = 'sys_tablespace' ENGINE = EXPRESS,\n PARTITION p4 VALUES LESS THAN (50) TABLESPACE = 'sys_tablespace' ENGINE = EXPRESS) |\n+-------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+\n1 row in set (Elapsed: 00:00:00.00)\n\ngbase> select * from t_p partition (p0);\n+------+------+\n| a | b |\n+------+------+\n| 1 | 1111 |\n+------+------+\n1 row in set (Elapsed: 00:00:00.00)\n\ngbase> select * from t_p partition (p1);\n+------+--------+\n| a | b |\n+------+--------+\n| 10 | 101010 |\n| 15 | 151515 |\n+------+--------+\n2 rows in set (Elapsed: 00:00:00.00)\n\ngbase> select * from t_p partition (p3);\n+------+--------+\n| a | b |\n+------+--------+\n| 20 | 202020 |\n| 25 | 252525 |\n| 30 | 303030 |\n+------+--------+\n3 rows in set (Elapsed: 00:00:00.00)<\/span>\n\ngbase> select * from t_p partition (p4);\n+------+--------+\n| a | b |\n+------+--------+\n| 40 | 404040 |\n+------+--------+\n1 row in set (Elapsed: 00:00:00.00)<\/code><\/pre>\n\n\n\n<\/p>\n\n\n\n
<\/span>\u62c6\u5206\u5206\u533a<\/span><\/h2>\n\n\n\n\u4e0e\u5408\u5e76\u76f8\u53cd\u64cd\u4f5c\uff0c\u6211\u4eec\u5c06p3\u5206\u533a\uff0c\u62c6\u5206\u6210p2\u548cp3\uff0c\u6062\u590d\u539f\u59cb\u7684\u5206\u533a\u5c5e\u6027\u3002\u8bf7\u7ee7\u7eed\u5ffd\u7565\u5206\u533a\u540d\u5b57\uff0c\u4e3b\u8981\u662f\u5206\u533a\u5c5e\u6027\u3002<\/p>\n\n\n\n
\u4ece\u64cd\u4f5c\u7ed3\u679c\u770b\uff0c\u62c6\u5206\u540e\u7684p2\u67092\u884c\u6570\u636e\uff0cp3\u67091\u884c\u6570\u636e\uff0c\u4e0e\u9884\u671f\u76f8\u7b26\u3002<\/p>\n\n\n\n
gbase> alter table t_p reorganize partition p3 into(partition p2 values less than(30),partition p3 values less than(40));\r\nQuery OK, 0 rows affected (Elapsed: 00:00:01.75)\r\n\r\ngbase> show create table t_p;\r\n+-------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+\r\n| Table | Create Table |\r\n+-------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+\r\n| t_p | CREATE TABLE \"t_p\" (\r\n \"a\" int(11) DEFAULT NULL,\r\n \"b\" varchar(10) DEFAULT NULL\r\n) ENGINE=EXPRESS DEFAULT CHARSET=utf8 TABLESPACE='sys_tablespace'\r\n PARTITION BY RANGE (a)\r\n(PARTITION p0 VALUES LESS THAN (10) TABLESPACE = 'sys_tablespace' ENGINE = EXPRESS,\r\n PARTITION p1 VALUES LESS THAN (20) TABLESPACE = 'sys_tablespace' ENGINE = EXPRESS,\r\n PARTITION p2 VALUES LESS THAN (30) TABLESPACE = 'sys_tablespace' ENGINE = EXPRESS,\r\n PARTITION p3 VALUES LESS THAN (40) TABLESPACE = 'sys_tablespace' ENGINE = EXPRESS,\r\n PARTITION p4 VALUES LESS THAN (50) TABLESPACE = 'sys_tablespace' ENGINE = EXPRESS) |\r\n+-------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+\r\n1 row in set (Elapsed: 00:00:00.00)\r\n\r\ngbase> select * from t_p partition (p0);\r\n+------+------+\r\n| a | b |\r\n+------+------+\r\n| 1 | 1111 |\r\n+------+------+\r\n1 row in set (Elapsed: 00:00:00.02)\r\n\r\ngbase> select * from t_p partition (p1);\r\n+------+--------+\r\n| a | b |\r\n+------+--------+\r\n| 10 | 101010 |\r\n| 15 | 151515 |\r\n+------+--------+\r\n2 rows in set (Elapsed: 00:00:00.01)\r\n\r\ngbase> select * from t_p partition (p2);\r\n+------+--------+\r\n| a | b |\r\n+------+--------+\r\n| 20 | 202020 |\r\n| 25 | 252525 |\r\n+------+--------+\r\n2 rows in set (Elapsed: 00:00:00.01)\r\n\r\ngbase> select * from t_p partition (p3);\r\n+------+--------+\r\n| a | b |\r\n+------+--------+\r\n| 30 | 303030 |\r\n+------+--------+\r\n1 row in set (Elapsed: 00:00:00.00)\r\n\r\ngbase> select * from t_p partition (p4);\r\n+------+--------+\r\n| a | b |\r\n+------+--------+\r\n| 40 | 404040 |\r\n+------+--------+\r\n1 row in set (Elapsed: 00:00:00.01)<\/code><\/pre>\n\n\n\n<\/span>\u6ce8\u610f\u4e8b\u9879<\/span><\/h2>\n\n\n\n\u62c6\u5206\u4e0e\u5408\u5e76\u64cd\u4f5c\u540e\u7684\u5206\u533a\u5c5e\u6027\uff0c\u4e0d\u80fd\u4e0e\u73b0\u6709\u7684\u5176\u5b83\u5206\u533a\u5c5e\u6027\u51b2\u7a81\u3002<\/p>\n\n\n\n
\u5982\u4e0b\u4ee5\u62c6\u5206\u4e3a\u4f8b\uff0c\u65b0\u5206\u533a\u7684\u5c5e\u6027\u4e0e\u539f\u6709\u5c5e\u6027\u51b2\u7a81\u7684\u62a5\u9519\u4fe1\u606f\u3002<\/p>\n\n\n\n
gbase> alter table t_p reorganize partition p3 into(partition p2 values less than(30),partition p3 values less than(50));\r\nERROR 1702 (HY000): gcluster table error: Reorganize of range partitions cannot change total ranges except for last partition where it can extend the range.\r\ngbase> alter table t_p reorganize partition p3 into(partition p2 values less than(20),partition p3 values less than(40));\r\nERROR 1702 (HY000): gcluster table error: VALUES LESS THAN value must be strictly increasing for each partition.\r\ngbase><\/code><\/pre>\n\n\n\n<\/p>","protected":false},"excerpt":{"rendered":"
\u5357\u5927\u901a\u7528GBase 8a\u76849.5.3\u7248\u672c\u5c06\u652f\u6301\u5206\u533a\u7684\u91cd\u7ec4\uff0c\u5305\u62ec\u5408\u5e76\u591a\u4e2a\u5206\u533a\u52301\u4e2a\u5206\u533a\uff0c\u6216\u8005\u5c061\u4e2a\u5206\u533a\u62c6\u5206\u6210\u591a\u4e2a\u5206\u533a\uff0c\u672c\u6587\u4ecb\u7ecd\u5176\u4f7f\u7528\u65b9\u6cd5<\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[80],"class_list":["post-10371","post","type-post","status-publish","format-standard","hentry","category-gbase8a","tag-80"],"_links":{"self":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/10371","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/comments?post=10371"}],"version-history":[{"count":19,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/10371\/revisions"}],"predecessor-version":[{"id":10390,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/10371\/revisions\/10390"}],"wp:attachment":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/media?parent=10371"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/categories?post=10371"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/tags?post=10371"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}