Teradata Source Data Type | Databricks Target Data Type |
|---|---|
array | binary |
bigint | long |
blob | binary |
byte(precision), 1 <= p <= 64000 | binary |
byteint | integer |
char(size), 1 <= size <= 64000 | string |
clob | string |
date | string |
decimal(p,s), 1 <= p <= 38, 1 <= s <= 37 | decimal(p,s), 1 <= p <= 38, 1 <= s <= 37 |
float | double |
integer | integer |
interval day(precision) to hour, 1 <= p <= 4 | string |
interval day(precision) to minute, 1 <= p <= 4 | string |
interval day(precision) to second (s), 1 <= p <= 4, 0 <= s <= 6 | string |
interval day(precision), 1 <= p <= 4 | string |
interval hour(precision) to minute, 1 <= p <= 4 | string |
interval hour(precision) to second (s), 1 <= p <= 4, 0 <= s <= 6 | string |
interval hour(precision), 1 <= p <= 4 | string |
interval minute(precision) to second (s), 1 <= p <= 4, 0 <= s <= 6 | string |
interval minute(precision), 1 <= p <= 4 | string |
interval month(precision), 1 <= p <= 4 | string |
interval second(p,s), 1 <= p <= 4, 0 <= s <= 6 | string |
interval year(precision) to month, 1 <= p <= 4 | string |
interval year(precision), 1 <= p <= 4 | string |
json | string |
mbr | binary |
number(*,s), 0 <= s <= 37 | string |
number(p,s), 1 <= p <= 38, 1 <= s <= 37 | decimal(p,s), 1 <= p <= 38, 1 <= s <= 37 |
numeric(p,s), 1 <= p <= 38, 1 <= s <= 37 | decimal(p,s), 1 <= p <= 38, 1 <= s <= 37 |
period(date) | string |
period(time(precision) with time zone), 0 <= p <= 6 | string |
period(time(precision) ), 0 <= p <= 6 | string |
period(timestamp(precision) with time zone), 0 <= p <= 6 | string |
period(timestamp(precision) ), 0 <= p <= 6 | string |
smallint | integer |
time(precision) with time zone, 0 <= p <= 6 | string |
time(precision), 0 <= p <= 6 | string |
timestamp(precision) with time zone, 0 <= p <= 6 | timestamp |
timestamp(precision), 0 <= p <= 6 | timestamp |
varbyte(precision), 1 <= p <= 64000 | binary |
varchar(size), 1 <= size <= 64000 | string |
varray | binary |
xml | string |