更新日期:2024年09月11日
示例
建表语句:
CREATE TABLE "test_2" (
"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
GBase 8a MPP Cluster 产品手册
5 数据库管理指南
文档版本953(2022-04-10)
南大通用数据技术股份有限公司
1216
03890|lqps,rpd|gg
加载过程:
gbase> LOAD DATA INFILE 'http://192.168.153.32/1.txt' INTO TABLE
test_2 FIELDS TERMINATED BY '|' MAX_BAD_RECORDS 1;
ERROR 1733 (HY000): (GBA-01EX-700) Gbase general error: Task 268 failed,
[192.168.153.32:5050](GBA-02AD-0005)Failed to query in gnode:
DETAIL: (GBA-01-600) Gbase internal error: Task 268, Too many bad
records!SQL: LOAD /*+ TID('11471') */ DATA INFILE
'http://192.168.153.32/1.txt#offset=0&length=58&firstblock&ffsize=58' INTO
TABLE `test`.`test_2_n1` DATA_FORMAT 3 FIELDS TERMINATED BY ','
MAX_BAD_RECORDS 1 HOST '192.168.153.32' CURRENT_TIMESTAMP
1510598427 SCN_NUMBER 268 GCLUSTER_PORT 5258 INTO SERVER
查询入库数据:
gbase> SELECT * FROM test_2;
Empty set (Elapsed: 00:00:00.03)