<\/span><\/h2>\n\n\n\n8.6.2.43-R35.5\n9.5.3.28.18<\/code><\/pre>\n\n\n\n<\/span>\u6574\u5f62\u5206\u5e03\u5217<\/span><\/h2>\n\n\n\n\u539f\u5219\u4e0a\uff0c\u54c8\u5e0chash\u5206\u5e03\u5217\uff0c\u4f7f\u7528int\u548cbigint\u5373\u53ef\u3002\u5176\u5b83\u7684smallint\u548ctinyint\u867d\u7136\u8bed\u6cd5\u4e0a\u6ca1\u62a5\u9519\uff0c\u4f46\u4ece\u5b9e\u9645\u751f\u4ea7\u73af\u5883\u770b\uff0c\u4e0d\u5efa\u8bae\u4f7f\u7528\u3002<\/p>\n\n\n\n
<\/span>int<\/span><\/h3>\n\n\n\ngbase> create table td_int(id int,name varchar(100))distributed by('id');\r\nQuery OK, 0 rows affected (Elapsed: 00:00:00.23)\n\ngbase> show create table td_int;\r\n+--------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+\r\n| Table | Create Table |\r\n+--------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+\r\n| td_int | CREATE TABLE \"td_int\" (\r\n \"id\" int(11) DEFAULT NULL,\r\n \"name\" varchar(100) DEFAULT NULL\r\n) ENGINE=EXPRESS DISTRIBUTED BY('id') DEFAULT CHARSET=utf8 TABLESPACE='sys_tablespace' |\r\n+--------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+\r\n1 row in set (Elapsed: 00:00:00.00)<\/code><\/pre>\n\n\n\n<\/span>bigint<\/span><\/h3>\n\n\n\ngbase> create table td_bigint(id bigint,name varchar(100))distributed by('id');\r\nQuery OK, 0 rows affected (Elapsed: 00:00:00.21)\r\n\ngbase> show create table td_bigint;\r\n+-----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+\r\n| Table | Create Table |\r\n+-----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+\r\n| td_bigint | CREATE TABLE \"td_bigint\" (\r\n \"id\" bigint(20) DEFAULT NULL,\r\n \"name\" varchar(100) DEFAULT NULL\r\n) ENGINE=EXPRESS DISTRIBUTED BY('id') DEFAULT CHARSET=utf8 TABLESPACE='sys_tablespace' |\r\n+-----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+\r\n1 row in set (Elapsed: 00:00:00.00)<\/code><\/pre>\n\n\n\n<\/span>smallint<\/span><\/h3>\n\n\n\ngbase> create table td_smallint(id smallint,name varchar(100))distributed by('id');\r\nQuery OK, 0 rows affected (Elapsed: 00:00:00.24)\r\n\r\ngbase> show create table td_smallint;\r\n+-------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+\r\n| Table | Create Table |\r\n+-------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+\r\n| td_smallint | CREATE TABLE \"td_smallint\" (\r\n \"id\" smallint(6) DEFAULT NULL,\r\n \"name\" varchar(100) DEFAULT NULL\r\n) ENGINE=EXPRESS DISTRIBUTED BY('id') DEFAULT CHARSET=utf8 TABLESPACE='sys_tablespace' |\r\n+-------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+\r\n1 row in set (Elapsed: 00:00:00.00)\r\n<\/code><\/pre>\n\n\n\n<\/span>\u5b57\u7b26\u578b\u5206\u5e03\u5217<\/span><\/h2>\n\n\n\n\u4ec5\u652f\u6301varchar\u7c7b\u578b\uff0c\u4e0d\u652f\u6301char\u7c7b\u578b\u548ctext\u7c7b\u578b\u3002<\/p>\n\n\n\n
gbase> create table td_char(id tinyint,name char(100))distributed by('name');\r\nERROR 1721 (HY000): (GBA-02DD-0003) Type of distributed column 'name' is incorrect.\r\ngbase>\r\ngbase> create table td_text(id tinyint,name text)distributed by('name');\r\nERROR 1721 (HY000): (GBA-02DD-0003) Type of distributed column 'name' is incorrect.\r\ngbase>\r\n<\/code><\/pre>\n\n\n\n<\/span>varchar<\/span><\/h3>\n\n\n\ngbase> create table td_varchar(id tinyint,name varchar(100))distributed by('name');\r\nQuery OK, 0 rows affected (Elapsed: 00:00:00.20)\r\n\r\ngbase> show create table td_varchar;\r\n+------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+\r\n| Table | Create Table |\r\n+------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+\r\n| td_varchar | CREATE TABLE \"td_varchar\" (\r\n \"id\" tinyint(4) DEFAULT NULL,\r\n \"name\" varchar(100) DEFAULT NULL\r\n) ENGINE=EXPRESS DISTRIBUTED BY('name') DEFAULT CHARSET=utf8 TABLESPACE='sys_tablespace' |\r\n+------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+\r\n1 row in set (Elapsed: 00:00:00.00)\r\n\r\ngbase>\r\n<\/code><\/pre>\n\n\n\n<\/span>decimal\u5206\u5e03\u5217<\/span><\/h2>\n\n\n\ngbase> create table td_decimal(id decimal(18,3),name text)distributed by('id');\r\nQuery OK, 0 rows affected (Elapsed: 00:00:00.22)\r\n\r\ngbase> show create table td_decimal;\r\n+------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------+\r\n| Table | Create Table |\r\n+------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------+\r\n| td_decimal | CREATE TABLE \"td_decimal\" (\r\n \"id\" decimal(18,3) DEFAULT NULL,\r\n \"name\" text\r\n) ENGINE=EXPRESS DISTRIBUTED BY('id') DEFAULT CHARSET=utf8 TABLESPACE='sys_tablespace' |\r\n+------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------+\r\n1 row in set (Elapsed: 00:00:00.00)\r\n<\/code><\/pre>","protected":false},"excerpt":{"rendered":"GBase 8a \u7248\u672c\u652f\u6301\u6574\u5f62(int,bigint)\uff0c\u5b57\u7b26\u578b(varchar)\u548cdecimal\u7c7b\u578b\u7684\u5b57\u6bb5\uff0c\u4f5c\u4e3a\u54c8\u5e0chash\u5206\u5e03\u5217\u3002<\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-12556","post","type-post","status-publish","format-standard","hentry","category-gbase8a"],"_links":{"self":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/12556","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=12556"}],"version-history":[{"count":3,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/12556\/revisions"}],"predecessor-version":[{"id":13017,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/12556\/revisions\/13017"}],"wp:attachment":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/media?parent=12556"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/categories?post=12556"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/tags?post=12556"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}