说明:
AUTOFILL:用于设定是否启用缺失列自动补齐功能,启用该参数后,对缺失分割符的字段数据按照 default 值或者 NULL 值进行加载,默认不自动补齐。
建表语句:
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> select * from t;
+------+--------+------+
| a | b | c |
+------+--------+------+
| 2 | second | NULL |
| 1 | first | NULL |
+------+--------+------+
2 rows in set