{"id":1651,"date":"2020-09-24T07:06:24","date_gmt":"2020-09-23T23:06:24","guid":{"rendered":"http:\/\/www.gbase8.cn\/?p=1651"},"modified":"2020-09-24T07:06:26","modified_gmt":"2020-09-23T23:06:26","slug":"gbase-8a%e7%9a%84%e5%a6%82%e4%bd%95%e6%8b%bf%e5%88%b0%e8%a1%8c%e5%8f%b7%ef%bc%8crowid%ef%bc%8c%e7%b1%bb%e4%bc%bcoracle%e7%9a%84rowid","status":"publish","type":"post","link":"https:\/\/www.gbase8.cn\/en\/1651","title":{"rendered":"\u5357\u5927\u901a\u7528GBase 8a\u7684\u5982\u4f55\u62ff\u5230\u884c\u53f7\uff0crowid\uff0c\u7c7b\u4f3coracle\u7684rowid"},"content":{"rendered":"<p>\u672c\u6587\u4ecb\u7ecdGBase 8a\u6570\u636e\u5e93\u96c6\u7fa4\u5185\u90e8\uff0c\u5bf9\u6ca1\u4e00\u884c\u6570\u636e\u7684\u884c\u53f7rowid\u7684\u65b9\u6848\u3002\u5982Oracle\u7b49\u6570\u636e\u5e93\uff0c\u63d0\u4f9b\u4e86rowid\u6765\u552f\u4e00\u6807\u8bc6\u4e00\u884c\u6570\u636e\uff0c\u5728GBase\u91cc\u4e5f\u63d0\u4f9b\u4e86rowid,\u4f46\u56e0\u4e3a\u662fMPP,\u6240\u4ee5\u5728\u968f\u673a\u5206\u5e03\u8868\u91cc\uff0c\u6bcf\u4e2a\u8282\u70b9\u662f\u5404\u81ea\u72ec\u7acb\u7684\uff0c\u53ea\u6709\u590d\u5236\u8868\u624d\u80fd\u4fdd\u8bc1\u4e00\u81f4\u6027\u3002<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_84 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Directory Navigation<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6a2ac42f5b41a\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewbox=\"0 0 24 24\" version=\"1.2\" baseprofile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a2ac42f5b41a\"  aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1' ><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.gbase8.cn\/en\/1651\/#%E6%B5%8B%E8%AF%95%E7%8E%AF%E5%A2%83\" >\u6d4b\u8bd5\u73af\u5883<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.gbase8.cn\/en\/1651\/#%E6%B5%8B%E8%AF%95hash%E5%88%86%E5%B8%83%E8%A1%A8%E7%9A%84%E8%A1%8C%E5%8F%B7rowid\" >\u6d4b\u8bd5hash\u5206\u5e03\u8868\u7684\u884c\u53f7rowid<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.gbase8.cn\/en\/1651\/#%E6%B5%8B%E8%AF%95%E9%9A%8F%E6%9C%BA%E5%88%86%E5%B8%83%E8%A1%A8%E8%A1%8C%E5%8F%B7rowid\" >\u6d4b\u8bd5\u968f\u673a\u5206\u5e03\u8868\u884c\u53f7rowid<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.gbase8.cn\/en\/1651\/#%E6%B5%8B%E8%AF%95%E5%A4%8D%E5%88%B6%E8%A1%A8%E8%A1%8C%E5%8F%B7rowid\" >\u6d4b\u8bd5\u590d\u5236\u8868\u884c\u53f7rowid<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.gbase8.cn\/en\/1651\/#%E7%BB%93%E8%AE%BA\" >\u7ed3\u8bba<\/a><\/li><\/ul><\/nav><\/div>\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E6%B5%8B%E8%AF%95%E7%8E%AF%E5%A2%83\"><\/span>\u6d4b\u8bd5\u73af\u5883<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>2\u8282\u70b9\u96c6\u7fa4<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&#91;gbase@localhost ~]$ gcadmin\nCLUSTER STATE:  ACTIVE\nCLUSTER MODE:   NORMAL\n\n=================================================================\n|             GBASE COORDINATOR CLUSTER INFORMATION             |\n=================================================================\n|   NodeName   |     IpAddress     |gcware |gcluster |DataState |\n-----------------------------------------------------------------\n| coordinator1 |    10.0.2.107     | OPEN  |  OPEN   |    0     |\n-----------------------------------------------------------------\n| coordinator2 |    10.0.2.106     | OPEN  |  OPEN   |    0     |\n-----------------------------------------------------------------\n=============================================================\n|              GBASE DATA CLUSTER INFORMATION               |\n=============================================================\n|NodeName |     IpAddress     |gnode |syncserver |DataState |\n-------------------------------------------------------------\n|  node1  |    10.0.2.107     | OPEN |   OPEN    |    0     |\n-------------------------------------------------------------\n|  node2  |    10.0.2.106     | OPEN |   OPEN    |    0     |\n-------------------------------------------------------------\n<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E6%B5%8B%E8%AF%95hash%E5%88%86%E5%B8%83%E8%A1%A8%E7%9A%84%E8%A1%8C%E5%8F%B7rowid\"><\/span>\u6d4b\u8bd5hash\u5206\u5e03\u8868\u7684\u884c\u53f7rowid<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u968f\u673a\u8868\u7684rowid, \u4f1a\u51fa\u73b0\u91cd\u590d\u7684\uff0c\u56e0\u4e3a\u6bcf\u4e2a\u6570\u636e\u8282\u70b9\u90fd\u662f\u4ece0\u5f00\u59cb\u7684rowid\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>gbase> create table test_rowid(id int, value varchar(100)) distributed by('id');\nQuery OK, 0 rows affected (Elapsed: 00:00:00.26)\n\ngbase> insert into test_rowid values(1,'111'),(2,'2222'),(3,'3333');\nQuery OK, 3 rows affected (Elapsed: 00:00:00.16)\nRecords: 3  Duplicates: 0  Warnings: 0\n\ngbase> insert into test_rowid values(4,'444'),(5,'555'),(6,'666');\nQuery OK, 3 rows affected (Elapsed: 00:00:00.21)\nRecords: 3  Duplicates: 0  Warnings: 0\n\ngbase> insert into test_rowid values(7,'777'),(8,'888'),(9,'999');\nQuery OK, 3 rows affected (Elapsed: 00:00:00.13)\nRecords: 3  Duplicates: 0  Warnings: 0\n\ngbase> select rowid,t.* from test_rowid t;\n+-------+------+-------+\n| rowid | id   | value |\n+-------+------+-------+\n|     0 |    1 | 111   |\n|     1 |    2 | 2222  |\n|     2 |    3 | 3333  |\n|     3 |    4 | 444   |\n|     4 |    5 | 555   |\n|     0 |    6 | 666   |\n|     1 |    7 | 777   |\n|     2 |    8 | 888   |\n|     3 |    9 | 999   |\n+-------+------+-------+\n9 rows in set (Elapsed: 00:00:00.00)\n\ngbase> ^CAborted\n<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E6%B5%8B%E8%AF%95%E9%9A%8F%E6%9C%BA%E5%88%86%E5%B8%83%E8%A1%A8%E8%A1%8C%E5%8F%B7rowid\"><\/span>\u6d4b\u8bd5\u968f\u673a\u5206\u5e03\u8868\u884c\u53f7rowid<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u4f9d\u7136\u4f1a\u51fa\u73b0\u91cd\u590d\u7684\u884c\u53f7rowid<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&#91;gbase@localhost ~]$ cat test_rowid.txt\n11,1111111\n22,22222222\n33,333333333\n44,44444444\n55,555555555\n66,666666666\n77,7777777777\n88,8888888888\n&#91;gbase@localhost ~]$\n\ngbase> create table test_rowid_2(id int, value varchar(100));\nQuery OK, 0 rows affected (Elapsed: 00:00:00.27)\n\ngbase> load data infile 'sftp:\/\/gbase:gbase1234@10.0.2.107\/\/home\/gbase\/test_rowid.txt' into table test_rowid_2 fields terminated by ',';\nQuery OK, 8 rows affected (Elapsed: 00:00:00.98)\nTask 1835164 finished, Loaded 8 records, Skipped 0 records\n\ngbase> select rowid,t.* from test_rowid_2 t;\n+-------+------+------------+\n| rowid | id   | value      |\n+-------+------+------------+\n|     0 |   11 | 1111111    |\n|     1 |   33 | 333333333  |\n|     2 |   55 | 555555555  |\n|     3 |   77 | 7777777777 |\n|     0 |   22 | 22222222   |\n|     1 |   44 | 44444444   |\n|     2 |   66 | 666666666  |\n|     3 |   88 | 8888888888 |\n+-------+------+------------+\n8 rows in set (Elapsed: 00:00:00.01)\n\n\n<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E6%B5%8B%E8%AF%95%E5%A4%8D%E5%88%B6%E8%A1%A8%E8%A1%8C%E5%8F%B7rowid\"><\/span>\u6d4b\u8bd5\u590d\u5236\u8868\u884c\u53f7rowid<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u56e0\u4e3a\u590d\u5236\u8868\uff0c\u6bcf\u4e2a\u8282\u70b9\u6570\u636e\u90fd\u4e00\u6837\uff0c\u6240\u4ee5\u884c\u53f7rowid\u662f\u552f\u4e00\u7684\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>\ngbase> create table test_rowid_r(id int, value varchar(100)) replicated;\nQuery OK, 0 rows affected (Elapsed: 00:00:00.17)\n\ngbase> load data infile 'sftp:\/\/gbase:gbase1234@10.0.2.107\/\/home\/gbase\/test_rowid.txt' into table test_rowid_r fields terminated by ',';\nQuery OK, 8 rows affected (Elapsed: 00:00:00.90)\nTask 1835166 finished, Loaded 8 records, Skipped 0 records\n\ngbase> select rowid,t.* from test_rowid_r t;\n+-------+------+------------+\n| rowid | id   | value      |\n+-------+------+------------+\n|     0 |   11 | 1111111    |\n|     1 |   22 | 22222222   |\n|     2 |   33 | 333333333  |\n|     3 |   44 | 44444444   |\n|     4 |   55 | 555555555  |\n|     5 |   66 | 666666666  |\n|     6 |   77 | 7777777777 |\n|     7 |   88 | 8888888888 |\n+-------+------+------------+\n8 rows in set (Elapsed: 00:00:00.01)\n\n<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E7%BB%93%E8%AE%BA\"><\/span>\u7ed3\u8bba<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u5728\u5f53\u524d\u5df2\u7ecf\u53d1\u884c\u7684\u7248\u672c\uff0c\u7531\u4e8e\u884c\u53f7rowid\u662f\u4f9d\u8d56\u6570\u636e\u8282\u70b9\u672c\u8eab\u7684\uff0c\u6240\u4ee5\u96c6\u7fa4\u5c42\u5e76\u6ca1\u6709\u7edf\u4e00\u7684\u4e00\u4e2a\u884c\u53f7\uff0c\u6240\u4ee5\u5982\u679c\u9700\u8981\u884c\u53f7\uff0c\u53ef\u4ee5\u7528\u590d\u5236\u8868\u3002<\/p>\n\n\n\n<p>\u4ece\u4e1a\u52a1\u4e0a\uff0c\u8fd8\u662f\u5e0c\u671b\u7528\u6237\u81ea\u884c\u7ba1\u7406\u7c7b\u4f3c\u529f\u80fd\uff0c\u6bd4\u5982\u65b0\u7684V9\u7248\u672c\u652f\u6301\u4e86\u81ea\u589e\u5217\uff0c\u4e0d\u8981\u4f9d\u8d56\u884c\u53f7\u3002<\/p>\n\n\n\n<figure class=\"wp-block-embed-wordpress wp-block-embed is-type-wp-embed is-provider-\u8001\u7d2b\u7af9\u7684\u5bb6\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"T7Aj8YERdb\"><a href=\"http:\/\/www.gbase8.cn\/en\/1073\/\">GBase 8a \u5728V95\u7248\u672c\u5bf9\u8868\u81ea\u589e\u5217\u7684\u652f\u6301\u6837\u4f8b<\/a><\/blockquote><iframe loading=\"lazy\" title=\"\u300aGBase 8a \u5728V95\u7248\u672c\u5bf9\u8868\u81ea\u589e\u5217\u7684\u652f\u6301\u6837\u4f8b\u300b\u2014\u8001\u7d2b\u7af9\u7684\u5bb6\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" src=\"http:\/\/www.gbase8.cn\/1073\/embed#?secret=T7Aj8YERdb\" data-secret=\"T7Aj8YERdb\" width=\"600\" height=\"338\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<p><\/p>","protected":false},"excerpt":{"rendered":"<p>\u672c\u6587\u4ecb\u7ecdGBase 8a\u6570\u636e\u5e93\u96c6\u7fa4\u5185\u90e8\uff0c\u5bf9\u6ca1\u4e00\u884c\u6570\u636e\u7684\u884c\u53f7rowid\u7684\u65b9\u6848\u3002\u5982Oracle\u7b49\u6570\u636e\u5e93\uff0c\u63d0\u4f9b\u4e86rowid\u6765\u552f\u4e00\u6807\u8bc6\u4e00\u884c\u6570\u636e\uff0c\u5728GBase\u91cc\u4e5f\u63d0\u4f9b\u4e86rowid,\u4f46\u56e0\u4e3a\u662fMPP,\u6240\u4ee5\u5728\u968f\u673a\u5206\u5e03\u8868\u91cc\uff0c\u6bcf\u4e2a\u8282\u70b9\u662f\u5404\u81ea\u72ec\u7acb\u7684\uff0c\u53ea\u6709\u590d\u5236\u8868\u624d\u80fd\u4fdd\u8bc1\u4e00\u81f4\u6027\u3002<\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1651","post","type-post","status-publish","format-standard","hentry","category-gbase8a"],"_links":{"self":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/1651","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=1651"}],"version-history":[{"count":3,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/1651\/revisions"}],"predecessor-version":[{"id":1656,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/1651\/revisions\/1656"}],"wp:attachment":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/media?parent=1651"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/categories?post=1651"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/tags?post=1651"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}