一、GP集群相关指令
#查看greenplum库各个节点数据的分布情况
select gp_segment_id,count(*) from table_name group by gp_segment_id;
#查看greenplum中单表前1000条数据
SELECT * FROM "public"."company_ar" LIMIT 1000 OFFSET 0
二、MySQL导入导出命令
1.导出
copy 表名 to '路径.csv' with csv; #路径必须默认mysql-files 我的是:/var/lib/mysql-files/
2.导入
(1)先建立和csv相同表结构
(2)将csv文件放到指定目录mysql-files 我的是:/var/lib/mysql-files/
load data infile "/var/lib/mysql-files/company_ar.csv"
replace into table 表名
character set gb2312
fields terminated by "," enclosed by ""
lines terminated by "/r/n";