说明:
TERMINATED BY:行分隔符,支持任意单字符,参数值以引号包围。指定方式与包围符一样。默认行分隔符为’\n’。
加载示例:
部分数据文件:
1|1551894|76910|1|17|33078.94|0.04|0.02|N|O|1996-03-13|1996-02-12|1996-03-22|"WHO ARE YOU"|TRUCK|egular courts above the|
1|673091|73092|2|36|38306.16|0.09|0.06|N|O|1996-04-12|1996-02-28|1996-04-20|"Take BACK"|MAIL|ly final dependencies: slyly bold |
加载过程:
gbase> LOAD DATA INFILE 'ftp://192.168.0.1/pub/lineitem.tbl' INTO TABLE test.lineitem
FIELDS TERMINATED BY '|' ENCLOSED BY '"' LINES TERMINATED BY '\n';
Query OK, 12000000 rows affected
Task 1 finished, Loaded 12000000 records, Skipped 0 records