当前位置: 代码迷 >> 综合 >> gbase集群加载入库与导出文件
  详细解决方案

gbase集群加载入库与导出文件

热度:66   发布时间:2023-09-29 10:05:31.0

背景:常用加载与导出语句,与其他数据库基本无差,mark下

脚本里的sql执行

`cat /opt/script/gbase/gbase.txt` -Dstg_noas -vvv -f</opt/script/temp/test.sql

用户密码通常写在gbase.txt中

加载:

load data infile 'ftp://user:pwd@ip/dir/*.gz' 
into  table table_name
FIELDS TERMINATED BY '|' ENCLOSED BY '"' 
 autofill
LINES TERMINATED BY '\n';

导出:

select * from table_name
into outfile '/opt/script/temp/1111.txt'

FIELDS TERMINATED BY '\t'