Datatype Mapping Reference

Back Next

MySQL Source and Greenplum Target

The following table identifies the recommended datatype mappings for Data Replication configurations with a MySQL source and a Greenplum target:

MySQL Source Datatype	Greenplum Target Datatype	Comments
BIGINT	NUMERIC(20,0)	-
BINARY	BYTEA	-
BIT	NUMERIC(20,0)	-
BLOB	BYTEA	-
CHAR(`n`)	CHAR(`n`)	-
DATE	DATE	-
DATETIME(`n`)	TIMESTAMP(0) Mapping condition: `n` == -1 TIMESTAMP(`n`) Mapping condition: `n` != -1	-
DECIMAL(`p`,`s`)	NUMERIC(`p`,`s`)	-
DOUBLE	FLOAT	-
ENUM	VARCHAR(255)	-
FLOAT	REAL	-
INT	BIGINT	-
LONGBLOB	BYTEA	-
LONGTEXT	TEXT	-
MEDIUMBLOB	BYTEA	-
MEDIUMINT	INTEGER	-
MEDIUMTEXT	TEXT	-
SET	VARCHAR(4000)	-
SMALLINT	INTEGER	-
TEXT	TEXT	-
TIME(`n`)	TIME(0) Mapping condition: `n` == -1 TIME(`n`) Mapping condition: `n` != -1	-
TIMESTAMP(`n`)	TIMESTAMP(0) Mapping condition: `n` == -1 TIMESTAMP(`n`) Mapping condition: `n` != -1	-
TINYBLOB	BYTEA	-
TINYINT	SMALLINT	-
TINYTEXT	VARCHAR(255)	-
VARBINARY	BYTEA	-
VARCHAR(`n`)	VARCHAR(`n`)	-
YEAR	INTEGER	-