• GP中表的范围 Ø 最大时间为年表 Ø 数据量小，可用单表 • 多种表类型 Ø 堆表 （选好常用列作为三列键） Ø 分区表 （按照 yyyymmdd 分区，建议都添加 datenum int8） Ø append表 Ø 列存储表 Ø 多种表类型结合 • 表的命名 Ø GP内所有名称都小写 Ø table_name命名要符合命名规则，做到见名知义 36 Greenplum开发规范

Documentation VMware by Broadcom 763 PostgreSQL Java bool boolean char byte int2 short int4 int int8 long varchar java.lang.String text java.lang.String bytea byte[ ] date java.sql.Date time java may lose accuracy when compared to the original input. Name Alias Size Range Description bigint int8 8 bytes -922337203 6854775808 to 922337203 6854775807 large range integer bigserial serial8 8 bytes LTZ::BIGINT; int8 --------------------- 1672502400123456000 (1 row) =# SELECT '1969-01-01 00:00:00.123456 Asia/Shanghai'::TIMESTAMP9_LTZ::BIGINT; int8 --------------------

offset[, default]) and lead(value, offset[, default]) window functions has changed from data type int8 (bigint) in Greenplum 4.3 and 5 to int4 (integer) in Greenplum 6. If you used these functions to offset[, default]) and lead(value, offset[, default]) window functions has changed from data type int8 (bigint) in Greenplum 4.3 and 5 to int4 (integer) in Greenplum 6. If you used these functions to Documentation VMware by Broadcom 974 PostgreSQL Java bool boolean char byte int2 short int4 int int8 long varchar java.lang.String text java.lang.String bytea byte[ ] date java.sql.Date time java

offset[, default]) and lead(value, offset[, default]) window functions has changed from data type int8 (bigint) in Greenplum 4.3 and 5 to int4 (integer) in Greenplum 6. If you used these functions to offset[, default]) and lead(value, offset[, default]) window functions has changed from data type int8 (bigint) in Greenplum 4.3 and 5 to int4 (integer) in Greenplum 6. If you used these functions to table lists the current mappings. PostgreSQL Java bool boolean char byte int2 short int4 int int8 long varchar java.lang.String text java.lang.String bytea byte[ ] date java.sql.Date time java

offset[, default]) and lead(value, offset[, default]) window functions has changed from data type int8 (bigint) in Greenplum 4.3 and 5 to int4 (integer) in Greenplum 6. If you used these functions to create offset[, default]) and lead(value, offset[, default]) window functions has changed from data type int8 (bigint) in Greenplum 4.3 and 5 to int4 (integer) in Greenplum 6. If you used these functions to create table lists the current mappings. PostgreSQL Java bool boolean char byte int2 short int4 int int8 long varchar java.lang.String text java.lang.String bytea byte[ ] VMware Greenplum 6 Documentation

offset[, default]) and lead(value, offset[, default]) window functions has changed from data type int8 (bigint) in Greenplum 4.3 and VMware Tanzu Greenplum 6 Documentation VMware, Inc 390 5 to int4 offset[, default]) and lead(value, offset[, default]) window functions has changed from data type int8 (bigint) in Greenplum 4.3 and 5 to int4 (integer) in Greenplum 6. If you used these functions to table lists the current mappings. PostgreSQL Java bool boolean char byte int2 short int4 int int8 long varchar java.lang.String text java.lang.String bytea byte[ ] date java.sql.Date time java

offset[, default]) and lead(value, offset[, default]) window functions has changed from data type int8 (bigint) in Greenplum 4.3 and 5 to int4 (integer) in Greenplum 6. If you used these functions to offset[, default]) and lead(value, offset[, default]) window functions has changed from data type int8 (bigint) in Greenplum 4.3 and 5 to int4 (integer) in Greenplum 6. If you used these functions to table lists the current mappings. PostgreSQL Java bool boolean char byte int2 short int4 int int8 long varchar java.lang.String text java.lang.String bytea byte[ ] date java.sql.Date time java

offset[, default]) and lead(value, offset[, default]) window functions has changed from data type int8 (bigint) in Greenplum 4.3 and 5 to int4 (integer) in Greenplum 6. If you used these functions to offset[, default]) and lead(value, offset[, default]) window functions has changed from data type int8 (bigint) in Greenplum 4.3 and 5 to int4 (integer) in Greenplum 6. If you used these functions to table lists the current mappings. PostgreSQL Java bool boolean char byte int2 short int4 int int8 long varchar java.lang.String text java.lang.String bytea byte[ ] date java.sql.Date time java

Database 5. The offset argument of the lag(expr, offset[, default]) window function has changed from int8 in Greenplum 4.3 to int4 in Greenplum 5 and 6. gpbackup saves the distribution policy and distribution Table 1. PL/Java data type mapping PostgreSQL Java bool boolean char byte int2 short int4 int int8 long varchar java.lang.String text java.lang.String bytea byte[ ] date java.sql.Date time java input. Table 1. Greenplum Database Built-in Data Types Name Alias Size Range Description bigint int8 8 bytes -922337203 6854775808 to 922337203 6854775807 large range integer bigserial serial8 8

Database 5. The offset argument of the lag(expr, offset[, default]) window function has changed from int8 in Greenplum 4.3 to int4 in Greenplum 5 and 6. gpbackup saves the distribution policy and distribution boolean char byte int2 short VMware Greenplum v6.19 Documentation VMware, Inc. 444 int4 int int8 long varchar java.lang.String text java.lang.String bytea byte[ ] date java.sql.Date time java input. Table 1. Greenplum Database Built-in Data Types Name Alias Size Range Description bigint int8 8 bytes -922337203 6854775808 to 922337203 6854775807 large range integer bigserial serial8 8