SAP HANA Source Data Type | Amazon Redshift Target Data Type |
|---|---|
alphanum(precision), 1 <= p <= 127 | character(size), 1 <= size <= 127 |
array | binary varying(1024000) |
bigint | bigint |
binary(size), 1 <= size <= 2000 | binary varying(size), 1 <= size <= 2000 |
boolean | boolean |
char(size), 1 <= size <= 2000 | character(size), 1 <= size <= 2000 |
date | date |
decimal | character varying(255) |
decimal(38,38) | character varying(41) |
decimal(p,s), 1 <= p <= 38, 0 <= s <= 37 | numeric(p,s), 1 <= p <= 38, 0 <= s <= 37 |
double | double precision |
float | double precision |
integer | integer |
nchar(size), 1 <= size <= 2000 | character varying(size), 4 <= size <= 8000 |
nvarchar(size), 1 <= size <= 5000 | character varying(size), 4 <= size <= 20000 |
real | real |
seconddate | timestamp without time zone |
shorttext(precision), 1 <= p <= 5000 | character varying(size), 1 <= size <= 5000 |
smalldecimal | character varying(255) |
smallint | smallint |
st_geometry | binary varying(1024000) |
st_point | binary varying(1024000) |
time | time without time zone |
timestamp | character varying(27) |
timestamp | timestamp without time zone |
tinyint | smallint |
varbinary(size), 1 <= size <= 5000 | binary varying(size), 1 <= size <= 5000 |
varchar(size), 1 <= size <= 5000 | character varying(size), 1 <= size <= 5000 |