本文继续介绍南大通用GBase 8a数据库常用运维命令。
导入导出：
1.加载分隔符文本
load data infile 'ftp://用户:密码@10.33.37.130//home/data/bms.dat' into table test.bms data_format 3 character set gbk null_value 'nullnull' fields terminated by '|' datetime format '%Y-%m-%d日 %H:%i:%s' lines terminated by '/n' autofill trace 1;
2.加载定长文本
LOAD DATA INFILE 'http://127.0.0.1/data/b.tbl' INTO TABLE test.b DATA_FORMAT 4 FIELDS DEFINER '4,6,10,12,1,19' TABLE_FIELDS 'no,pwd,birth date "%Y年%m月%d日",filler,sex,loginTime date "%Y-%m-%d %T"';
3.导出到本地
rmt:select * from nation into outfile '/home/gbase/new.txt' FIELDS TERMINATED BY '|' ENCLOSED BY '"' lines terminated by '@@@@@';
4.加载高可用的HDFS
namenode存在主备的需要设置以下参数 填写namenode的IP
set gbase_hdfs_namenodes="192.168.10.1,192.168.10.2";
加载语句 用户@主namenodeIP:50070/数据文件在hdfs的绝对路径 ， 库.表名
load data infile 'hdp://root@192.168.10.1:50070/why/test6/test.txt' into table test.test1 ;
5.hdfs导出
把Hadoop的主机名添加到 /etc/hosts
select * from test.test1 into outfile 'hdp://root@10.10.3.117:50070/why/test1' outfilemode by hdfs fields terminated by '|' ENCLOSED by '"' ;
空间清理：
DML后释放表空间
alter table 表名 shrink space full;
