Zhong Weicheng Study Notes

gp_toolkit Administrative Schema: The Greenplum Database includes the gp_toolkit schema, which collects system information through log files and operating system commands. You can run a query against

Oracle端表结构SQL> select dbms_metadata.get_ddl('TABLE','TAB_ORA','ZWC') from dual; CREATE TABLE "ZWC"."TAB_ORA" ( "ID" NUMBER, "OWNER" VARCHAR2(30), "NAME" VARCHAR2(128),

JDBC is the driver used to access a database with Java. Greenplum has a full working JDBC implementation.In this short article we’ll see how to use it.## Download and installIt is possible t

Example 1—Single Greenplum file server (gpfdist) instance on multiple NIC machineCreates a readable external table named ext_expenses using the gpfdist protocol. The files are formatted with a pipe

set /etc/sysctl.confkernel.shmmax = 500000000kernel.shmmni = 4096kernel.shmall = 4000000000kernel.sem = 250 512000 100 2048kernel.sysrq = 1kernel.core_uses_pid = 1kernel.msgmnb = 65536kerne

[gpadmin@gp01 gpdata]$ cat /gpdata/greenplum-db/cfg/scp_key gp01gp02gp03[gpadmin@gp01 gpdata]$ tar -jcvf greenplum-db-4.2.3.1.tar.bz2 greenplum-db-4.2.3.1[gpadmin@gp01 gpdata]$ gpscp -f /gpdata/g

创建一张表,在没有primary key 或者 unique key 的情况下，GreenPlum默认会把第一个column作为分布键zwcdb=# create table tab01(id int,name varchar(20));NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'id'

表大小zwcdb=# select pg_size_pretty(pg_relation_size('gp_test')); pg_size_pretty ---------------- 1761 MB(1 row)表和索引zwcdb=# select pg_size_pretty(pg_total_relation_size('gp_test')); pg_size_pr

源端Oracle 11.2.0.4 RAC 2-NodesOracle Linux 5.8 x86_64目标端Greenplum Database 4.2.6.1 4-NodesCentOS 5.7 x86_64======================================================源端配置--本例是将OGG安