GBase8a导入导出使用示例

LOAD DATA INFILE 'sftp://gbase:gba943@AFC3@10.133.151.118/data/ora_data/picc_order_detail_info_used.test' INTO TABLE sjsdata.picc_order_detail_info_used DATA_FORMAT 3 FIELDS TERMINATED BY '|,@' lines terminated by '|@\n' null_value 'gbasenull' CHARACTER SET utf8;

--加载时指定表字段
LOAD DATA INFILE 'file:///home/gbase/0408.txt/0408.txt' INTO TABLE test.t4 DATA_FORMAT 3 FIELDS TERMINATED BY '|,@' TABLE_FIELDS 'id1' lines terminated by '|@\n' null_value 'gbasenull'; --不写ip时，需保证每台服务器上都有目标数据文件

LOAD DATA INFILE 'file://192.168.64.139/home/gbase/0930.txt' INTO TABLE t7 DATA_FORMAT 3 FIELDS TERMINATED BY '|,@'lines terminated by '|@\n' null_value 'gbasenull';
--加载时的空格处理
--在加载功能中，如果平面文件中的两个列分割符中间的数据存在前后空格，默认的行为是trim掉前后空格入库，如果想保留空格入库，则需要在加载控制参数中补充preserve blanks参数用于屏蔽trim空格的行为。
LOAD DATA INFILE 'file://192.168.64.139/home/gbase/0930.txt' INTO TABLE t7 DATA_FORMAT 3 FIELDS TERMINATED BY '|,@'lines terminated by '|@\n' null_value 'gbasenull' preserve blanks;

select * from test_a into outfile '/home/gbase/0930.txt' FIELDS TERMINATED BY '|,@' lines terminated by '|@\n' null_value 'gbasenull';
--如果数据中有转义字符，如\ 可添加如下参数
FIELDS ESCAPED BY '' 完整命令如下：
select * from t7 into outfile '/home/gbase/0930.txt' FIELDS ESCAPED BY '' FIELDS TERMINATED BY '|,@' lines terminated by '|@\n' null_value 'gbasenull';
--导出到sftp
select * from ssbm.lineorder into outfile 'sftp://gbase:Admin2o11o531@192.168.56.163/home/gbase/exportdir/lineorder' fields terminated by '|' ;