GBase 8a MPP Cluster 产品手册 5 数据库管理指南 文档版本953(2022-09-15) 南大通用数据技术股份有限公司 1009 1 row in set (Elapsed: 00:00:00.00) 示例3:哈希分布表上创建自增列 gbase> CREATE TABLE t3(name varchar(10),id int not null primary key auto_increment) distributed by ('name'); Query OK, 0 rows affected (Elapsed: 00:00:00.08) gbase> SHOW CREATE TABLE t3 \G *************************** 1. row *************************** Table: t3 Create Table: CREATE TABLE "t3" ( "name" varchar(10) DEFAULT NULL, "id" int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY ("id") ) ENGINE=EXPRESS DISTRIBUTED BY('name') DEFAULT CHARSET=utf8 TABLESPACE='sys_tablespace' 1 row in set (Elapsed: 00:00:00.00) 示例4:分区表上创建自增列 gbase> CREATE TABLE t4(i int default 0,id int auto_increment primary key ) partition by range(i) partitions 2 subpartition by hash(i) subpartitions 2 ( partition p0 values less than (50001) (subpartition sb0, subpartition sb1 ), partition p1 values less than (100001)
GBase 8a MPP Cluster 产品手册 5 数据库管理指南 文档版本953(2022-09-15) 南大通用数据技术股份有限公司 1010 (subpartition sb10, subpartition sb11 ) ) ; Query OK, 0 rows affected (Elapsed: 00:00:00.11) gbase> SHOW CREATE TABLE t4 \G *************************** 1. row *************************** Table: t4 Create Table: CREATE TABLE "t4" ( "i" int(11) DEFAULT '0', "id" int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY ("id") ) ENGINE=EXPRESS DEFAULT CHARSET=utf8 TABLESPACE='sys_tablespace' PARTITION BY RANGE (i) SUBPARTITION BY HASH (i) (PARTITION p0 VALUES LESS THAN (50001) (SUBPARTITION sb0 ENGINE = EXPRESS, SUBPARTITION sb1 ENGINE = EXPRESS), PARTITION p1 VALUES LESS THAN (100001) (SUBPARTITION sb10 ENGINE = EXPRESS, SUBPARTITION sb11 ENGINE = EXPRESS)) 1 row in set (Elapsed: 00:00:00.01)
GBA-02DD-0020 错误码 错误标识 错误信息 GBA-02DD-002 0 无 Currently, we don't support renaming more than one tables at the same time 错误出现原因 不允许在同一条SQL 中同时重命名多个表。 分析与建议 把一条rename table 根据表,拆分成若干条rename table 后重试即可