This documentation is for an older version of HVR.
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 |