Default forward data type mappings for Greenplum data sources

The following table lists the default forward data type mappings for Greenplum data sources.

Table 1. Greenplum default forward data type mappings
Remote Typename Remote Lower Len Remote Upper Len Remote Lower Scale Remote Upper Scale Remote Bit Data Remote Data Operators Federated Typename Federated Length Federated Scale Federated Bit Data
BIT 1 1 - - - - BOOLEAN 1 0 N
BIT 2 254 - - - - BINARY n 0 N
BIT 255 32672 - - - - VARBINARY n/8+1 0 N
BIT 32673 83886080 - - - - VARBINARY n/8+1,<=32672 0 N
BIT VARYING 1 83886080 - - - - VARBINARY n/8+1,<=32672 N
INTEGER - - - - - - INTEGER 4 0 N
BIGINT - - - - - - BIGINT 8 0 N
SMALLINT - - - - - - SMALLINT 2 0 N
REAL - - - - - - REAL 4 0 N
NUMERIC/DECIMAL - - - - - - DOUBLE 8 0 N
NUMERIC/DECIMAL 1 31 1 31 - - DECIMAL - - N
NUMERIC/DECIMAL 32 1000 1 - - - DOUBLE 8 0 N
DOUBLE PRECISION - - - - - - DOUBLE 8 0 N
BIGSERIAL - - - - - - BIGINT 8 0 N
SERIAL - - - - - - INTEGER 4 0 N
BOOLEAN - - - - - - BOOLEAN 1 0 N
BYTEA - - - - - - BLOB 2147483647 0 N
TEXT - - - - - - CLOB 2147483647 0 N
CHARACTER 1 254 - - - - CHARACTER 0 0 N
CHARACTER 255 32672 - - - - VARCHAR n 0 N
CHARACTER 32673 10485760 - - - - VARCHAR 32672 0 N
CHARACTER VARYING 1 32672 - - - VARCHAR n 0 N
CHARACTER VARYING 32673 10485760 - - - VARCHAR 32672 0 N
DATE - - - - - - DATE - - N
TIME [without time zone ] - - - - - - TIME - - N
TIME with time zone - - - - - - - VARCHAR 21 -
TIME [without time zone ] - - - - - - TIMESTAMP - - N
TIME with time zone - - - - - - TIMESTAMP - - N
Note: In TIMESTAMP with time zone, the ODBC driver will map it to SQL_VARCHAR. Therefore, in Db2 it will map to varchar by default. If you want it map to TIMESTAMP in Db2, you can use this command to set : 
alter server server_name OPTIONS(add CUSTOMIZED_ODBC_ATTRIBUTES ';FetchTSWTZasTimestamp=1');