示例
建表语句:
CREATE TABLE t(a int,b VARCHAR(10),c VARCHAR(10));
数据文件:
1|first
2|second
加载过程:
gbase> LOAD DATA INFILE 'ftp://192.168.88.141/load_data/autofill.tbl'
INTO TABLE test.t FIELDS TERMINATED BY '|'
AUTOFILL;
Query OK, 2 rows affected, 3 warnings (Elapsed: 00:00:00.84)
Task 1107 finished, Loaded 2 records, Skipped 0 records
GBase 8a MPP Cluster 产品手册
5 数据库管理指南
文档版本953(2022-04-10)
南大通用数据技术股份有限公司
1212
查询入库数据:
gbase> SELECT * FROM dual;
+------+--------+------+
| a
| b
| c
|
+------+--------+------+
|
2 | second | NULL |
|
1 | first
| NULL |
+------+--------+------+
2 rows in set