<\/span><\/h3>\n\n\n\n[gbase@rh6-1 ~]$ gccli testdb\r\n\r\nGBase client 8.6.2.43-R30.124361. Copyright (c) 2004-2020, GBase. All Rights Reserved.\r\n\r\ngbase> set global gbase_loader_logs_collect=1;\r\nQuery OK, 0 rows affected (Elapsed: 00:00:00.02)\r\n\r\ngbase> show variables like '%collect%';\r\n+---------------------------+-------+\r\n| Variable_name | Value |\r\n+---------------------------+-------+\r\n| gbase_loader_logs_collect | ON |\r\n+---------------------------+-------+\r\n1 row in set (Elapsed: 00:00:00.00)\r\n\r\ngbase> load data infile 'sftp:\/\/gbase:gbase1234@10.0.2.201\/home\/gbase\/1.txt' into table t1;\r\nQuery OK, 0 rows affected (Elapsed: 00:00:00.67)\r\nTask 2686986 finished, Loaded 0 records, Skipped 11 records\r\n\r\ngbase> ^CAborted\r\n[gbase@rh6-1 ~]$ ll \/opt\/gcluster\/log\/gcluster\/loader_logs\/2686986\/\r\ntotal 12\r\n-rw------- 1 gbase gbase 209 Dec 28 15:24 2686986_loader_result.log\r\n-rw------- 1 gbase gbase 108 Dec 28 15:24 2686986_testdb_t1_n1_::ffff:10.0.2.202_20201228152453.err\r\n-rw------- 1 gbase gbase 886 Dec 28 15:24 2686986_testdb_t1_n1_::ffff:10.0.2.202_20201228152453.trc\r\n[gbase@rh6-1 ~]$\r\n<\/code><\/pre>\n\n\n\n<\/span>\u53c2\u6570\u5173\u6389\u540e\u7684\u6548\u679c<\/span><\/h3>\n\n\n\n[gbase@rh6-1 ~]$ gccli testdb\r\n\r\nGBase client 8.6.2.43-R30.124361. Copyright (c) 2004-2020, GBase. All Rights Reserved.\r\n\r\ngbase> show variables like '%collect%';\r\n+---------------------------+-------+\r\n| Variable_name | Value |\r\n+---------------------------+-------+\r\n| gbase_loader_logs_collect | ON |\r\n+---------------------------+-------+\r\n1 row in set (Elapsed: 00:00:00.00)\r\n\r\ngbase> set gbase_loader_logs_collect=0;\r\nERROR 1229 (HY000): Variable 'gbase_loader_logs_collect' is a GLOBAL variable and should be set with SET GLOBAL\r\ngbase> set global gbase_loader_logs_collect=0;\r\nQuery OK, 0 rows affected (Elapsed: 00:00:00.01)\r\n\r\ngbase>\r\ngbase>\r\ngbase>\r\ngbase>\r\ngbase> use testdb;\r\nQuery OK, 0 rows affected (Elapsed: 00:00:00.00)\r\n\r\ngbase> desc t1;\r\n+-------+---------+------+-----+---------+-------+\r\n| Field | Type | Null | Key | Default | Extra |\r\n+-------+---------+------+-----+---------+-------+\r\n| id | int(11) | YES | | NULL | |\r\n+-------+---------+------+-----+---------+-------+\r\n1 row in set (Elapsed: 00:00:00.00)\r\n\r\ngbase> load data infile 'sftp:\/\/gbase:gbase1234@10.0.2.201\/home\/gbase\/1.txt' into table t1;\r\nQuery OK, 0 rows affected (Elapsed: 00:00:00.70)\r\nTask 2686984 finished, Loaded 0 records, Skipped 11 records\r\n\r\ngbase> ^CAborted\r\n[gbase@rh6-1 ~]$ ll \/opt\/gnode\/log\/gbase\/loader_logs\/\r\ntotal 8\r\n-rw------- 1 gbase gbase 108 Dec 28 14:58 2686984_testdb_t1_n1_::ffff:10.0.2.201_20201228145807.err\r\n-rw------- 1 gbase gbase 886 Dec 28 14:58 2686984_testdb_t1_n1_::ffff:10.0.2.201_20201228145807.trc\r\n[gbase@rh6-1 ~]$ gncli\r\n<\/code><\/pre>\n\n\n\n<\/p>","protected":false},"excerpt":{"rendered":"
\u5357\u5927\u901a\u7528GBase 8a\u901a\u8fc7load\u52a0\u8f7d\u65f6\uff0c\u662f\u7531\u6570\u636e\u8282\u70b9\u505a\u6700\u7ec8\u7684\u5b9e\u8d28\u64cd\u4f5c\uff0c\u5982\u679c\u51fa\u73b0\u9519\u8bef\u6570\u636e\uff0c\u65e5\u5fd7\u4e5f\u662f\u8bb0\u5f55\u5728\u6570\u636e\u8282\u70b9\u3002\u5f53\u8282\u70b9\u6570\u91cf\u5f88\u591a\u65f6\uff0c\u4e0d\u65b9\u4fbf\u6392\u67e5\u3002\u901a\u8fc7gbase_loader_logs_collect\u53c2\u6570\uff0c\u53ef\u4ee5\u5c06\u9519\u8bef\u6570\u636e\u81ea\u52a8\u6536\u96c6\u5230\u8fde\u63a5\u8282\u70b9\u7684gcluster\u5927\u7684log\u76ee\u5f55\u4e0b\u3002<\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,6],"tags":[10],"class_list":{"0":"post-2586","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"hentry","6":"category-gbase8a","8":"tag-10"},"_links":{"self":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/2586","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=2586"}],"version-history":[{"count":1,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/2586\/revisions"}],"predecessor-version":[{"id":2587,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/2586\/revisions\/2587"}],"wp:attachment":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/media?parent=2586"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/categories?post=2586"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/tags?post=2586"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}