示例
建表语句:
CREATE TABLE "test_9" (
"column_1" int(11) DEFAULT NULL,
"column_2" varchar(10) DEFAULT NULL,
"column_3" varchar(20)
DEFAULT NULL);
数据文件:
43452|sisoekso|mozoa,a
59432|gg|laqpqpd
03890|lqps,rpd|gg
加载过程:
gbase> LOAD DATA INFILE 'http://192.168.153.32/1.txt' INTO TABLE
test_9 FIELDS TERMINATED BY '||' TRACE 1 TRACE_PATH
'/home/gbase/test/';
Query OK, 0 rows affected (Elapsed: 00:00:00.19)
Task 264 finished, Loaded 0 records, Skipped 3 records
查询日志文件:
[gbase@localhost 11]$ pwd
GBase 8a MPP Cluster 产品手册
5 数据库管理指南
文档版本953(2022-04-10)
南大通用数据技术股份有限公司
1221
/home/gbase/test
[gbase@localhost 11]$ ll
total 8
-rw-rw---- 1 gbase gbase
58 Nov 13 13:36
267_test_test_2_n1_192.168.153.32_20171113133614.err
-rw-rw---- 1 gbase gbase 392 Nov 13 13:36
267_test_test_2_n1_192.168.153.32_20171113133614.trc