示例
建表语句:
CREATE TABLE "test_3" (
"column_1" int(11) DEFAULT NULL,
"column_2" varchar(10) DEFAULT NULL,
"column_3" varchar(20)
DEFAULT NULL);
数据文件,1.txt 内容与2.txt 完全一致:
-rw-r--r-- 1 root root
58 Nov 13 09:13 1.txt
--w------- 1 root root
58 Nov 13 09:21 2.txt
指定skip_bad_file 为0:
gbase>LOAD DATA INFILE 'http://192.168.153.32/*.txt' INTO TABLE test_3
FIELDS TERMINATED BY '|' SKIP_BAD_FILE 0;
ERROR 1733 (HY000): (GBA-01EX-700) Gbase general error: Expanding
wildcard operation failed with error - I/O operation on http://192.168.153.32/2.txt
failed with error - Access denied to remote resource, HTTP/1.1 403 Forbidden, File
name http://192.168.153.32/2.txt uri : http://192.168.153.32/%2a.txt.
查询入库数据:
gbase> SELECT * FROM test_3;
Empty set (Elapsed: 00:00:00.00)
指定skip_bad_file 为1:
gbase> LOAD DATA INFILE 'http://192.168.153.32/*.txt' INTO TABLE
test_3 FIELDS TERMINATED BY '|' SKIP_BAD_FILE 1;
Query OK, 3 rows affected (Elapsed: 00:00:00.58)
Task 42 finished, Loaded 3 records, Skipped 0 records, Ignored 1 files
查询入库数据:
GBase 8a MPP Cluster 产品手册
5 数据库管理指南
文档版本953(2022-04-10)
南大通用数据技术股份有限公司
1217
gbase> SELECT * FROM test_3;
+----------+----------+----------+
| column_1 | column_2 | column_3 |
+----------+----------+----------+
|
43452 | sisoekso | mozoa,a
|
|
3890 | lqps,rpd | gg
|
|
59432 | gg
| laqpqpd
|
+----------+----------+----------+
3 rows in set (Elapsed: 00:00:00.01)