Data Type Mapping for Migration from Teradata to DWS

BIGINT

BIGINT

Yes

BYTEINT

SMALLINT

Yes

DECIMAL [(n[,m])]

DECIMAL [(n[,m])]

Yes

DOUBLE PRECISION

DOUBLE PRECISION

Yes

FLOAT

DOUBLE PRECISION

Yes

INT / INTEGER

INTEGER

Yes

NUMBER / NUMERIC

NUMERIC

Yes

NUMBER(n[,m])

NUMERIC (n[,m])

Yes

REAL

REAL

Yes

SMALLINT

SMALLINT

Yes

CHAR[(n)] / CHARACTER [(n)]

CHAR(n)

Yes

CLOB

CLOB

Yes

LONG VARCHAR

TEXT

Yes

VARCHAR(n) / CHAR VARYING(n) / CHARACTER VARYING(n)

VARCHAR(n)

Yes

DATE

DATE

Yes

TIME [(n)]

TIME [(n)]

Yes

TIME [(n)] WITH TIME ZONE

TIME [(n)] WITH TIME ZONE

Yes

TIMESTAMP [(n)]

TIMESTAMP [(n)]

Yes

TIMESTAMP [(n)] WITH TIME ZONE

TIMESTAMP [(n)] WITH TIME ZONE

Yes

PERIOD(DATE)

daterange

Yes

PERIOD(TIME [(n)])

tsrange [(n)]

Yes

PERIOD(TIME WITH TIME ZONE)

tstzrange

Yes

PERIOD(TIMESTAMP [(n)])

tsrange [(n)]

Yes

PERIOD(TIMESTAMP WITH TIME ZONE)

tstzrange

Yes

BLOB[(n)]

blob

Yes

BYTE[(n)]

bytea

Yes

VARBYTE[(n)]

bytea

Yes