Data Type Mapping for Teradata
This section lists the mapping of data types for Teradata.
Teradata as Source
When Teradata is used as a source location, following is the mapping of data types in Teradata to the corresponding HVR repository data type.
| Teradata | HVR Capture Support | HVR Repository Data Type |
|---|---|---|
| one-dimensional (1-d) array | Extended | <<A1>> |
| multidimensional (n-d) array | Extended | <<AN>> |
| byte | Native | byte |
| varbyte | Native | varbyte |
| blob | Native | blob |
| char | Native | char |
| varchar | Native | varchar |
| clob | Native | clob |
| avro | Extended | <<data type>> |
| date | Native | ansidate |
| time | Native | time |
| timestamp | Native | timestamp |
| time with time zone | Native | time with time zone |
| timestamp with time zone | Native | timestamp with time zone |
| st_geometry | Extended | <<data type>> |
| mbr | Extended | <<data type>> |
| interval year | Extended | <<YR>> |
| interval year to month | Native | interval year to month |
| interval month | Extended | <<MO>> |
| interval day | Extended | <<DY>> |
| interval day to hour | Extended | <<DH>> |
| interval day to minute | Extended | <<DM>> |
| interval day to second | Native | interval day to second |
| interval hour | Extended | <<HR>> |
| interval hour to minute | Extended | <<HM>> |
| interval hour to second | Extended | <<HS>> |
| interval minute | Extended | <<MI>> |
| interval minute to second | Extended | <<MS>> |
| interval second | Extended | <<SC>> |
| json | Extended | <<data type>> |
| byteint | Native | byteint |
| smallint | Native | smallint |
| integer | Native | integer |
| bigint | Native | bigint |
| decimal/numeric | Native | decimal |
| float/real/double precision | Native | double |
| number | Native | number |
| td_anytype | Extended | <<++>> |
| variant_type | Extended | <<data type>> |
| period(date) | Extended | <<PD>> |
| period(time) | Extended | <<PT>> |
| period(time with time zone) | Extended | <<PZ>> |
| period(timestamp) | Extended | <<PS>> |
| period(timestamp with time zone) | Extended | <<PM>> |
| distinct | Extended | <<UT>> |
| structured | Extended | <<data type>> |
| xml | Extended | <<XM>> |
Teradata as Target
When Teradata is used as a target location, following is the mapping of HVR repository data types to the corresponding data type in Teradata.
Text in green cell indicates the native data type of the DBMS
| HVR Repository Data Types | Attributes | Teradata |
|---|---|---|
| ansidate (ingres) | null=1 | date |
| ansidate | null=1 | date |
| bfile | null=1 | blob(2097088000) |
| bigint unsigned |
bytelen=8
null=1 | decimal(20) |
| bigint |
bytelen=8
null=1 | bigint |
| binary |
bytelen=10
null=1 | byte(10) |
| binary_double |
bytelen=8
null=1 | float |
| binary_float |
bytelen=4
null=1 | float |
| bit (mysql) |
bitlen=32
null=1 | varchar(32) char set latin casespecific |
| bit |
bytelen=1
null=1 | byteint |
| blob | null=1 | blob(2097088000) |
| bool |
bytelen=1
null=1 | byteint |
| boolean |
bytelen=1
null=1 | byteint |
| byte varying |
bytelen=10
null=1 | varbyte(10) |
| byte |
bytelen=10
null=1 | byte(10) |
| byteint |
bytelen=1
null=1 | byteint |
| c |
bytelen=10
encoding=UTF-8 null=1 | char(10) char set latin casespecific |
| char |
bytelen=10
encoding=UTF-8 null=1 | char(10) char set latin casespecific |
| char |
bytelen=4000
encoding=UTF-8 null=1 | char(4000) char set latin casespecific |
| char |
bytelen=8000
encoding=UTF-8 null=1 | char(8000) char set latin casespecific |
| char |
bytelen=40
charlen=10 encoding=UTF-8 null=1 | char(10) char set latin casespecific |
| char |
bytelen=10
encoding=WINDOWS-1252 null=1 | char(10) char set latin casespecific |
| char (oracle) |
bytelen=10
encoding=UTF-8 null=1 | char(10) char set latin casespecific |
| char (oracle) |
bytelen=2000
encoding=UTF-8 null=1 | char(2000) char set latin casespecific |
| char (oracle) |
bytelen=40
charlen=10 encoding=UTF-8 null=1 | char(10) char set latin casespecific |
| char (oracle) |
bytelen=10
encoding=WINDOWS-1252 null=1 | char(10) char set latin casespecific |
| clob |
encoding=UTF-8
null=1 | clob(2097088000) char set latin |
| date | null=1 | timestamp(0) |
| date (hana) | null=1 | date |
| date (mysql) | null=1 | date |
| date (sybase) | null=1 | date |
| datetime (bigquery) |
prec_sec=0
null=1 | timestamp(0) |
| datetime (mysql) |
prec_sec=0
null=1 | timestamp(0) |
| datetime (sybase) | null=1 | timestamp(3) |
| datetime | null=1 | timestamp(3) |
| datetime2 |
prec_sec=0
null=1 | timestamp(0) |
| datetimeoffset |
prec_sec=0
null=1 | timestamp(0) with time zone |
| db2 timestamp with time zone |
prec_sec=0
null=1 | timestamp(0) with time zone |
| db2 xml |
encoding=UTF-8
null=1 | clob(2097088000) char set latin |
| dbclob |
charlen=0
null=1 | clob(1048544000) char set unicode |
| decfloat |
prec=16
null=1 | varchar(42) char set latin casespecific |
| decfloat |
prec=34
null=1 | varchar(42) char set latin casespecific |
| decimal |
prec=10
scale=3 null=1 | decimal(10,3) |
| decimal |
prec=6
null=1 | decimal(6) |
| double |
bytelen=8
null=1 | float |
| epoch |
prec_sec=0
null=1 | timestamp(0) |
| float |
bytelen=8
null=1 | float |
| float4 |
bytelen=4
null=1 | float |
| float8 |
bytelen=8
null=1 | float |
| float64 |
bytelen=8
null=1 | float |
| graphic |
charlen=10
null=1 | char(10) char set unicode casespecific |
| image | null=1 | blob(2097088000) |
| image (sybase) | null=1 | blob(2097088000) |
| ingresdate | null=1 | timestamp(0) |
| int unsigned |
bytelen=4
null=1 | bigint |
| int |
bytelen=4
null=1 | integer |
| integer |
bytelen=4
null=1 | integer |
| integer1 |
bytelen=1
null=1 | byteint |
| integer2 |
bytelen=2
null=1 | smallint |
| integer4 |
bytelen=4
null=1 | integer |
| integer8 |
bytelen=8
null=1 | bigint |
| int64 |
bytelen=8
null=1 | bigint |
| interval day to second (ingres) |
prec_sec=0
null=1 | timestamp(0) |
| interval day to second |
prec_sec=0
prec_day=0 null=1 | timestamp(0) |
| interval month to second |
prec_sec=0
null=1 | timestamp(0) |
| interval year to month (ingres) | null=1 | timestamp(0) |
| interval year to month |
prec_year=0
null=1 | timestamp(0) |
| json | null=1 | clob(2097088000) char set latin |
| jsonb | null=1 | clob(2097088000) char set latin |
| long byte | null=1 | blob(2097088000) |
| long char |
encoding=UTF-8
null=1 | clob(2097088000) char set latin |
| long nvarchar (db2) |
charlen=0
null=1 | clob(1048544000) char set unicode |
| long nvarchar |
charlen=0
null=1 | clob(1048544000) char set unicode |
| long raw | null=1 | blob(2097088000) |
| long varbinary | null=1 | blob(2097088000) |
| long varchar (db2) |
encoding=UTF-8
null=1 | clob(2097088000) char set latin |
| long varchar |
encoding=UTF-8
null=1 | clob(2097088000) char set latin |
| long |
encoding=UTF-8
null=1 | clob(2097088000) char set latin |
| mediumint unsigned |
bytelen=3
null=1 | integer |
| mediumint |
bytelen=3
null=1 | integer |
| money (ingres) | null=1 | decimal(14,2) |
| money | null=1 | decimal(19,4) |
| nchar |
charlen=10
null=1 | char(10) char set unicode casespecific |
| nchar (oracle) |
bytelen=20
charlen=10 null=1 | char(10) char set unicode casespecific |
| nclob |
charlen=0
null=1 | clob(1048544000) char set unicode |
| ntext |
charlen=0
null=1 | clob(1048544000) char set unicode |
| number |
scale=0
null=1 | number |
| number |
prec=10
scale=-127 null=1 | float |
| number |
prec=10
scale=3 null=1 | number(10,3) |
| number |
prec=26
scale=0 null=1 | number(26) |
| number |
prec=6
scale=0 null=1 | number(6) |
| numeric (db2i) |
prec=10
scale=3 null=1 | decimal(10,3) |
| numeric (db2i) |
prec=6
null=1 | decimal(6) |
| numeric |
prec=10
scale=3 null=1 | decimal(10,3) |
| numeric |
prec=26
null=1 | decimal(26) |
| numeric |
prec=6
null=1 | decimal(6) |
| nvarchar |
charlen=10
null=1 | varchar(10) char set unicode casespecific |
| nvarchar(max) |
charlen=0
null=1 | clob(1048544000) char set unicode |
| nvarchar2 |
charlen=10
null=1 | varchar(10) char set unicode casespecific |
| postgres date | null=1 | date |
| postgres timestamp with time zone |
prec_sec=0
null=1 | timestamp(0) with time zone |
| postgres timestamp |
prec_sec=0
null=1 | timestamp(0) |
| raw |
bytelen=10
null=1 | varbyte(10) |
| real |
bytelen=4
null=1 | float |
| rowid |
bytelen=18
charlen=18 encoding=US-ASCII null=1 | char(18) char set latin casespecific |
| rowversion |
bytelen=10
null=1 | byte(10) |
| smalldatetime | null=1 | timestamp(0) |
| smallint unsigned |
bytelen=2
null=1 | integer |
| smallint |
bytelen=2
null=1 | smallint |
| smallmoney | null=1 | decimal(10,4) |
| text (ingres) |
bytelen=10
encoding=UTF-8 null=1 | varchar(10) char set latin casespecific |
| text (sqlserver) |
encoding=WINDOWS-1252
null=1 | clob(2097088000) char set latin |
| text(sybase) |
encoding=UTF-8
null=1 | clob(2097088000) char set latin |
| time (mysql) |
prec_sec=0
null=1 | time(0) |
| time (hana) | null=1 | time(0) |
| time (sybase) | null=1 | time(3) |
| time with local time zone |
prec_sec=0
null=1 | time(0) |
| time with time zone |
prec_sec=0
null=1 | time(0) with time zone |
| time |
prec_sec=0
null=1 | time(0) |
| time |
prec_sec=3
null=1 | time(3) |
| time2 | null=1 | time(0) |
| timestamp (bigquery) |
prec_sec=0
null=1 | timestamp(0) with time zone |
| timestamp (db2) |
prec_sec=0
null=1 | timestamp(0) |
| timestamp (hana) |
prec_sec=0
null=1 | timestamp(0) |
| timestamp (ingres) |
prec_sec=0
null=1 | timestamp(0) |
| timestamp (mysql) |
prec_sec=0
null=1 | timestamp(0) |
| timestamp (oracle) |
prec_sec=0
null=1 | timestamp(0) |
| timestamp (sqlserver) |
bytelen=10
null=1 | byte(10) |
| timestamp (sybase) |
bytelen=10
null=1 | varbyte(10) |
| timestamp with local time zone |
prec_sec=0
null=1 | timestamp(0) |
| timestamp with local tz (oracle) |
prec_sec=0
null=1 | timestamp(0) |
| timestamp with time zone |
prec_sec=0
null=1 | timestamp(0) with time zone |
| timestamp with tz (oracle) |
prec_sec=0
null=1 | timestamp(0) with time zone |
| timestamp |
prec_sec=0
null=1 | timestamp(0) |
| tinyint signed |
bytelen=1
null=1 | byteint |
| tinyint unsigned |
bytelen=1
null=1 | smallint |
| tinyint |
bytelen=1
null=1 | smallint |
| uniqueidentifier |
bytelen=16
null=1 | byte(16) |
| unitext |
charlen=0
null=1 | clob(1048544000) char set unicode |
| univarchar |
charlen=10
null=1 | varchar(10) char set unicode casespecific |
| unsigned bigint |
bytelen=8
null=1 | decimal(20) |
| unsigned int |
bytelen=4
null=1 | bigint |
| unsigned smallint |
bytelen=2
null=1 | integer |
| urowid |
bytelen=100
charlen=100 encoding=US-ASCII null=1 | varchar(100) char set latin casespecific |
| varbinary |
bytelen=10
null=1 | varbyte(10) |
| varbinary (sybase) |
bytelen=10
null=1 | varbyte(10) |
| varbinary(max) | null=1 | blob(2097088000) |
| varbyte |
bytelen=10
null=1 | varbyte(10) |
| varchar |
bytelen=10
encoding=UTF-8 null=1 | varchar(10) char set latin casespecific |
| varchar |
bytelen=8000
encoding=UTF-8 null=1 | varchar(8000) char set latin casespecific |
| varchar |
bytelen=40
charlen=10 encoding=UTF-8 null=1 | varchar(10) char set latin casespecific |
| varchar |
bytelen=10
encoding=WINDOWS-1252 null=1 | varchar(10) char set latin casespecific |
| varchar (sybase) |
bytelen=10
encoding=UTF-8 null=1 | varchar(10) char set latin casespecific |
| varchar (sybase) |
bytelen=8000
encoding=UTF-8 null=1 | varchar(8000) char set latin casespecific |
| varchar (sybase) |
bytelen=40
charlen=10 encoding=UTF-8 null=1 | varchar(10) char set latin casespecific |
| varchar (sybase) |
bytelen=10
encoding=WINDOWS-1252 null=1 | varchar(10) char set latin casespecific |
| varchar(max) |
encoding=WINDOWS-1252
null=1 | clob(2097088000) char set latin |
| varchar2 |
bytelen=10
encoding=UTF-8 null=1 | varchar(10) char set latin casespecific |
| varchar2 |
bytelen=40
charlen=10 encoding=UTF-8 null=1 | varchar(10) char set latin casespecific |
| varchar2 |
bytelen=10
encoding=WINDOWS-1252 null=1 | varchar(10) char set latin casespecific |
| vargraphic |
charlen=10
null=1 | varchar(10) char set unicode casespecific |
| xml |
charlen=0
null=1 | clob(1048544000) char set unicode |
| year (mysql) | null=1 | smallint |