This documentation is for an older version of HVR.
Data Type Mapping for Hive External Tables with Avro, CSV, Json, and Parquet
This section lists the mapping of data types for the Hive External Tables with file types Avro, CSV, Json, and Parquet.
Hive External Tables with Avro as Target
In a target location with Hive External Tables, when the file type is Avro, following is the mapping of HVR repository data types to the corresponding data type in Avro.
Text in green cell indicates the native data type of the DBMS
| HVR Repository Data Types | Attributes | Hive external table backed by Avro 1.8 |
|---|---|---|
| ansidate (ingres) | null=1 | date |
| ansidate | null=1 | date |
| bfile | null=1 | binary |
| bigint unsigned |
bytelen=8
null=1 | decimal(20) |
| bigint |
bytelen=8
null=1 | bigint |
| binary |
bytelen=10
null=1 | binary |
| binary_double |
bytelen=8
null=1 | double |
| binary_float |
bytelen=4
null=1 | float |
| bit (mysql) |
bitlen=32
null=1 | varchar(32) |
| bit |
bytelen=1
null=1 | boolean |
| blob | null=1 | binary |
| bool |
bytelen=1
null=1 | boolean |
| boolean |
bytelen=1
null=1 | boolean |
| byte varying |
bytelen=10
null=1 | binary |
| byte |
bytelen=10
null=1 | binary |
| byteint |
bytelen=1
null=1 | smallint |
| c |
bytelen=10
encoding=UTF-8 null=1 | char(10) |
| char |
bytelen=10
encoding=UTF-8 null=1 | char(10) |
| char |
bytelen=4000
encoding=UTF-8 null=1 | varchar(4000) |
| char |
bytelen=8000
encoding=UTF-8 null=1 | varchar(8000) |
| char |
bytelen=40
charlen=10 encoding=UTF-8 null=1 | char(10) |
| char |
bytelen=10
encoding=WINDOWS-1252 null=1 | char(10) |
| char (oracle) |
bytelen=10
encoding=UTF-8 null=1 | char(10) |
| char (oracle) |
bytelen=2000
encoding=UTF-8 null=1 | varchar(2000) |
| char (oracle) |
bytelen=40
charlen=10 encoding=UTF-8 null=1 | char(10) |
| char (oracle) |
bytelen=10
encoding=WINDOWS-1252 null=1 | char(10) |
| clob |
encoding=UTF-8
null=1 | string |
| date | null=1 | timestamp |
| date (hana) | null=1 | date |
| date (mysql) | null=1 | date |
| date (sybase) | null=1 | date |
| datetime (bigquery) |
prec_sec=0
null=1 | timestamp |
| datetime (mysql) |
prec_sec=0
null=1 | timestamp |
| datetime (sybase) | null=1 | timestamp |
| datetime | null=1 | timestamp |
| datetime2 |
prec_sec=0
null=1 | timestamp |
| datetimeoffset |
prec_sec=0
null=1 | timestamp |
| db2 timestamp with time zone |
prec_sec=0
null=1 | timestamp |
| db2 xml |
encoding=UTF-8
null=1 | string |
| dbclob |
charlen=0
null=1 | string |
| decfloat |
prec=16
null=1 | varchar(42) |
| decfloat |
prec=34
null=1 | varchar(42) |
| decimal |
prec=10
scale=3 null=1 | decimal(10,3) |
| decimal |
prec=6
null=1 | decimal(6) |
| double |
bytelen=8
null=1 | double |
| epoch |
prec_sec=0
null=1 | timestamp |
| float |
bytelen=8
null=1 | double |
| float4 |
bytelen=4
null=1 | float |
| float8 |
bytelen=8
null=1 | double |
| float64 |
bytelen=8
null=1 | double |
| graphic |
charlen=10
null=1 | char(10) |
| image | null=1 | binary |
| image (sybase) | null=1 | binary |
| ingresdate | null=1 | timestamp |
| int unsigned |
bytelen=4
null=1 | bigint |
| int |
bytelen=4
null=1 | int |
| integer |
bytelen=4
null=1 | int |
| integer1 |
bytelen=1
null=1 | smallint |
| integer2 |
bytelen=2
null=1 | smallint |
| integer4 |
bytelen=4
null=1 | int |
| integer8 |
bytelen=8
null=1 | bigint |
| int64 |
bytelen=8
null=1 | bigint |
| interval day to second (ingres) |
prec_sec=0
null=1 | varchar(100) |
| interval day to second |
prec_sec=0
prec_day=0 null=1 | varchar(100) |
| interval month to second |
prec_sec=0
null=1 | varchar(100) |
| interval year to month (ingres) | null=1 | varchar(100) |
| interval year to month |
prec_year=0
null=1 | varchar(100) |
| json | null=1 | string |
| jsonb | null=1 | string |
| long byte | null=1 | binary |
| long char |
encoding=UTF-8
null=1 | string |
| long nvarchar (db2) |
charlen=0
null=1 | string |
| long nvarchar |
charlen=0
null=1 | string |
| long raw | null=1 | binary |
| long varbinary | null=1 | binary |
| long varchar (db2) |
encoding=UTF-8
null=1 | string |
| long varchar |
encoding=UTF-8
null=1 | string |
| long |
encoding=UTF-8
null=1 | string |
| mediumint unsigned |
bytelen=3
null=1 | int |
| mediumint |
bytelen=3
null=1 | int |
| money (ingres) | null=1 | decimal(14,2) |
| money | null=1 | decimal(19,4) |
| nchar |
charlen=10
null=1 | char(10) |
| nchar (oracle) |
bytelen=20
charlen=10 null=1 | char(10) |
| nclob |
charlen=0
null=1 | string |
| ntext |
charlen=0
null=1 | string |
| number |
scale=0
null=1 | decimal(38,4) |
| number |
prec=10
scale=-127 null=1 | double |
| number |
prec=10
scale=3 null=1 | decimal(10,3) |
| number |
prec=26
scale=0 null=1 | decimal(26) |
| number |
prec=6
scale=0 null=1 | int |
| 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) |
| nvarchar(max) |
charlen=0
null=1 | string |
| nvarchar2 |
charlen=10
null=1 | varchar(10) |
| postgres date | null=1 | date |
| postgres timestamp with time zone |
prec_sec=0
null=1 | timestamp |
| postgres timestamp |
prec_sec=0
null=1 | timestamp |
| raw |
bytelen=10
null=1 | binary |
| real |
bytelen=4
null=1 | float |
| rowid |
bytelen=18
charlen=18 encoding=US-ASCII null=1 | char(18) |
| rowversion |
bytelen=10
null=1 | binary |
| smalldatetime | null=1 | timestamp |
| smallint unsigned |
bytelen=2
null=1 | int |
| smallint |
bytelen=2
null=1 | smallint |
| smallmoney | null=1 | decimal(10,4) |
| text (ingres) |
bytelen=10
encoding=UTF-8 null=1 | varchar(10) |
| text (sqlserver) |
encoding=WINDOWS-1252
null=1 | string |
| text(sybase) |
encoding=UTF-8
null=1 | string |
| time (mysql) |
prec_sec=0
null=1 | varchar(25) |
| time (hana) | null=1 | varchar(25) |
| time (sybase) | null=1 | varchar(25) |
| time with local time zone |
prec_sec=0
null=1 | varchar(25) |
| time with time zone |
prec_sec=0
null=1 | varchar(25) |
| time |
prec_sec=0
null=1 | varchar(25) |
| time |
prec_sec=3
null=1 | varchar(25) |
| time2 | null=1 | varchar(25) |
| timestamp (bigquery) |
prec_sec=0
null=1 | timestamp |
| timestamp (db2) |
prec_sec=0
null=1 | timestamp |
| timestamp (hana) |
prec_sec=0
null=1 | timestamp |
| timestamp (ingres) |
prec_sec=0
null=1 | timestamp |
| timestamp (mysql) |
prec_sec=0
null=1 | timestamp |
| timestamp (oracle) |
prec_sec=0
null=1 | timestamp |
| timestamp (sqlserver) |
bytelen=10
null=1 | binary |
| timestamp (sybase) |
bytelen=10
null=1 | binary |
| timestamp with local time zone |
prec_sec=0
null=1 | timestamp |
| timestamp with local tz (oracle) |
prec_sec=0
null=1 | timestamp |
| timestamp with time zone |
prec_sec=0
null=1 | timestamp |
| timestamp with tz (oracle) |
prec_sec=0
null=1 | timestamp |
| timestamp |
prec_sec=0
null=1 | timestamp |
| tinyint signed |
bytelen=1
null=1 | smallint |
| tinyint unsigned |
bytelen=1
null=1 | smallint |
| tinyint |
bytelen=1
null=1 | smallint |
| uniqueidentifier |
bytelen=16
null=1 | char(36) |
| unitext |
charlen=0
null=1 | string |
| univarchar |
charlen=10
null=1 | varchar(10) |
| unsigned bigint |
bytelen=8
null=1 | decimal(20) |
| unsigned int |
bytelen=4
null=1 | bigint |
| unsigned smallint |
bytelen=2
null=1 | int |
| urowid |
bytelen=100
charlen=100 encoding=US-ASCII null=1 | varchar(100) |
| varbinary |
bytelen=10
null=1 | binary |
| varbinary (sybase) |
bytelen=10
null=1 | binary |
| varbinary(max) | null=1 | binary |
| varbyte |
bytelen=10
null=1 | binary |
| varchar |
bytelen=10
encoding=UTF-8 null=1 | varchar(10) |
| varchar |
bytelen=8000
encoding=UTF-8 null=1 | varchar(8000) |
| varchar |
bytelen=40
charlen=10 encoding=UTF-8 null=1 | varchar(10) |
| varchar |
bytelen=10
encoding=WINDOWS-1252 null=1 | varchar(10) |
| varchar (sybase) |
bytelen=10
encoding=UTF-8 null=1 | varchar(10) |
| varchar (sybase) |
bytelen=8000
encoding=UTF-8 null=1 | varchar(8000) |
| varchar (sybase) |
bytelen=40
charlen=10 encoding=UTF-8 null=1 | varchar(10) |
| varchar (sybase) |
bytelen=10
encoding=WINDOWS-1252 null=1 | varchar(10) |
| varchar(max) |
encoding=WINDOWS-1252
null=1 | string |
| varchar2 |
bytelen=10
encoding=UTF-8 null=1 | varchar(10) |
| varchar2 |
bytelen=40
charlen=10 encoding=UTF-8 null=1 | varchar(10) |
| varchar2 |
bytelen=10
encoding=WINDOWS-1252 null=1 | varchar(10) |
| vargraphic |
charlen=10
null=1 | varchar(10) |
| xml |
charlen=0
null=1 | string |
| year (mysql) | null=1 | smallint |
Hive External Tables with CSV as Target
In a target location with Hive External Tables, when the file type is CSV, following is the mapping of HVR repository data types to the corresponding data type in CSV.
Text in green cell indicates the native data type of the DBMS
| HVR Repository Data Types | Attributes | Hive external table backed by CSV |
|---|---|---|
| ansidate (ingres) | null=1 | date |
| ansidate | null=1 | date |
| bfile | null=1 | binary |
| bigint unsigned |
bytelen=8
null=1 | decimal(20) |
| bigint |
bytelen=8
null=1 | bigint |
| binary |
bytelen=10
null=1 | binary |
| binary_double |
bytelen=8
null=1 | double |
| binary_float |
bytelen=4
null=1 | float |
| bit (mysql) |
bitlen=32
null=1 | varchar(32) |
| bit |
bytelen=1
null=1 | boolean |
| blob | null=1 | binary |
| bool |
bytelen=1
null=1 | boolean |
| boolean |
bytelen=1
null=1 | boolean |
| byte varying |
bytelen=10
null=1 | binary |
| byte |
bytelen=10
null=1 | binary |
| byteint |
bytelen=1
null=1 | smallint |
| c |
bytelen=10
encoding=UTF-8 null=1 | char(10) |
| char |
bytelen=10
encoding=UTF-8 null=1 | char(10) |
| char |
bytelen=4000
encoding=UTF-8 null=1 | varchar(4000) |
| char |
bytelen=8000
encoding=UTF-8 null=1 | varchar(8000) |
| char |
bytelen=40
charlen=10 encoding=UTF-8 null=1 | char(10) |
| char |
bytelen=10
encoding=WINDOWS-1252 null=1 | char(10) |
| char (oracle) |
bytelen=10
encoding=UTF-8 null=1 | char(10) |
| char (oracle) |
bytelen=2000
encoding=UTF-8 null=1 | varchar(2000) |
| char (oracle) |
bytelen=40
charlen=10 encoding=UTF-8 null=1 | char(10) |
| char (oracle) |
bytelen=10
encoding=WINDOWS-1252 null=1 | char(10) |
| clob |
encoding=UTF-8
null=1 | string |
| date | null=1 | timestamp |
| date (hana) | null=1 | date |
| date (mysql) | null=1 | date |
| date (sybase) | null=1 | date |
| datetime (bigquery) |
prec_sec=0
null=1 | timestamp |
| datetime (mysql) |
prec_sec=0
null=1 | timestamp |
| datetime (sybase) | null=1 | timestamp |
| datetime | null=1 | timestamp |
| datetime2 |
prec_sec=0
null=1 | timestamp |
| datetimeoffset |
prec_sec=0
null=1 | varchar(100) |
| db2 timestamp with time zone |
prec_sec=0
null=1 | varchar(100) |
| db2 xml |
encoding=UTF-8
null=1 | string |
| dbclob |
charlen=0
null=1 | string |
| decfloat |
prec=16
null=1 | varchar(42) |
| decfloat |
prec=34
null=1 | varchar(42) |
| decimal |
prec=10
scale=3 null=1 | decimal(10,3) |
| decimal |
prec=6
null=1 | decimal(6) |
| double |
bytelen=8
null=1 | double |
| epoch |
prec_sec=0
null=1 | timestamp |
| float |
bytelen=8
null=1 | double |
| float4 |
bytelen=4
null=1 | float |
| float8 |
bytelen=8
null=1 | double |
| float64 |
bytelen=8
null=1 | double |
| graphic |
charlen=10
null=1 | char(10) |
| image | null=1 | binary |
| image (sybase) | null=1 | binary |
| ingresdate | null=1 | timestamp |
| int unsigned |
bytelen=4
null=1 | bigint |
| int |
bytelen=4
null=1 | int |
| integer |
bytelen=4
null=1 | int |
| integer1 |
bytelen=1
null=1 | smallint |
| integer2 |
bytelen=2
null=1 | smallint |
| integer4 |
bytelen=4
null=1 | int |
| integer8 |
bytelen=8
null=1 | bigint |
| int64 |
bytelen=8
null=1 | bigint |
| interval day to second (ingres) |
prec_sec=0
null=1 | varchar(100) |
| interval day to second |
prec_sec=0
prec_day=0 null=1 | varchar(100) |
| interval month to second |
prec_sec=0
null=1 | varchar(100) |
| interval year to month (ingres) | null=1 | varchar(100) |
| interval year to month |
prec_year=0
null=1 | varchar(100) |
| json | null=1 | string |
| jsonb | null=1 | string |
| long byte | null=1 | binary |
| long char |
encoding=UTF-8
null=1 | string |
| long nvarchar (db2) |
charlen=0
null=1 | string |
| long nvarchar |
charlen=0
null=1 | string |
| long raw | null=1 | binary |
| long varbinary | null=1 | binary |
| long varchar (db2) |
encoding=UTF-8
null=1 | string |
| long varchar |
encoding=UTF-8
null=1 | string |
| long |
encoding=UTF-8
null=1 | string |
| mediumint unsigned |
bytelen=3
null=1 | int |
| mediumint |
bytelen=3
null=1 | int |
| money (ingres) | null=1 | decimal(14,2) |
| money | null=1 | decimal(19,4) |
| nchar |
charlen=10
null=1 | char(10) |
| nchar (oracle) |
bytelen=20
charlen=10 null=1 | char(10) |
| nclob |
charlen=0
null=1 | string |
| ntext |
charlen=0
null=1 | string |
| number |
scale=0
null=1 | decimal(38,4) |
| number |
prec=10
scale=-127 null=1 | double |
| number |
prec=10
scale=3 null=1 | decimal(10,3) |
| number |
prec=26
scale=0 null=1 | decimal(26) |
| number |
prec=6
scale=0 null=1 | int |
| 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) |
| nvarchar(max) |
charlen=0
null=1 | string |
| nvarchar2 |
charlen=10
null=1 | varchar(10) |
| postgres date | null=1 | date |
| postgres timestamp with time zone |
prec_sec=0
null=1 | varchar(100) |
| postgres timestamp |
prec_sec=0
null=1 | timestamp |
| raw |
bytelen=10
null=1 | binary |
| real |
bytelen=4
null=1 | float |
| rowid |
bytelen=18
charlen=18 encoding=US-ASCII null=1 | char(18) |
| rowversion |
bytelen=10
null=1 | binary |
| smalldatetime | null=1 | timestamp |
| smallint unsigned |
bytelen=2
null=1 | int |
| smallint |
bytelen=2
null=1 | smallint |
| smallmoney | null=1 | decimal(10,4) |
| text (ingres) |
bytelen=10
encoding=UTF-8 null=1 | varchar(10) |
| text (sqlserver) |
encoding=WINDOWS-1252
null=1 | string |
| text(sybase) |
encoding=UTF-8
null=1 | string |
| time (mysql) |
prec_sec=0
null=1 | varchar(25) |
| time (hana) | null=1 | varchar(25) |
| time (sybase) | null=1 | varchar(25) |
| time with local time zone |
prec_sec=0
null=1 | varchar(25) |
| time with time zone |
prec_sec=0
null=1 | varchar(25) |
| time |
prec_sec=0
null=1 | varchar(25) |
| time |
prec_sec=3
null=1 | varchar(25) |
| time2 | null=1 | varchar(25) |
| timestamp (bigquery) |
prec_sec=0
null=1 | varchar(100) |
| timestamp (db2) |
prec_sec=0
null=1 | timestamp |
| timestamp (hana) |
prec_sec=0
null=1 | timestamp |
| timestamp (ingres) |
prec_sec=0
null=1 | timestamp |
| timestamp (mysql) |
prec_sec=0
null=1 | timestamp |
| timestamp (oracle) |
prec_sec=0
null=1 | timestamp |
| timestamp (sqlserver) |
bytelen=10
null=1 | binary |
| timestamp (sybase) |
bytelen=10
null=1 | binary |
| timestamp with local time zone |
prec_sec=0
null=1 | varchar(100) |
| timestamp with local tz (oracle) |
prec_sec=0
null=1 | varchar(100) |
| timestamp with time zone |
prec_sec=0
null=1 | varchar(100) |
| timestamp with tz (oracle) |
prec_sec=0
null=1 | varchar(100) |
| timestamp |
prec_sec=0
null=1 | timestamp |
| tinyint signed |
bytelen=1
null=1 | smallint |
| tinyint unsigned |
bytelen=1
null=1 | smallint |
| tinyint |
bytelen=1
null=1 | smallint |
| uniqueidentifier |
bytelen=16
null=1 | char(36) |
| unitext |
charlen=0
null=1 | string |
| univarchar |
charlen=10
null=1 | varchar(10) |
| unsigned bigint |
bytelen=8
null=1 | decimal(20) |
| unsigned int |
bytelen=4
null=1 | bigint |
| unsigned smallint |
bytelen=2
null=1 | int |
| urowid |
bytelen=100
charlen=100 encoding=US-ASCII null=1 | varchar(100) |
| varbinary |
bytelen=10
null=1 | binary |
| varbinary (sybase) |
bytelen=10
null=1 | binary |
| varbinary(max) | null=1 | binary |
| varbyte |
bytelen=10
null=1 | binary |
| varchar |
bytelen=10
encoding=UTF-8 null=1 | varchar(10) |
| varchar |
bytelen=8000
encoding=UTF-8 null=1 | varchar(8000) |
| varchar |
bytelen=40
charlen=10 encoding=UTF-8 null=1 | varchar(10) |
| varchar |
bytelen=10
encoding=WINDOWS-1252 null=1 | varchar(10) |
| varchar (sybase) |
bytelen=10
encoding=UTF-8 null=1 | varchar(10) |
| varchar (sybase) |
bytelen=8000
encoding=UTF-8 null=1 | varchar(8000) |
| varchar (sybase) |
bytelen=40
charlen=10 encoding=UTF-8 null=1 | varchar(10) |
| varchar (sybase) |
bytelen=10
encoding=WINDOWS-1252 null=1 | varchar(10) |
| varchar(max) |
encoding=WINDOWS-1252
null=1 | string |
| varchar2 |
bytelen=10
encoding=UTF-8 null=1 | varchar(10) |
| varchar2 |
bytelen=40
charlen=10 encoding=UTF-8 null=1 | varchar(10) |
| varchar2 |
bytelen=10
encoding=WINDOWS-1252 null=1 | varchar(10) |
| vargraphic |
charlen=10
null=1 | varchar(10) |
| xml |
charlen=0
null=1 | string |
| year (mysql) | null=1 | smallint |
Hive External Tables with Json as Target
In a target location with Hive External Tables, when the file type is Json, following is the mapping of HVR repository data types to the corresponding data type in Json.
Text in green cell indicates the native data type of the DBMS
| HVR Repository Data Types | Attributes | Hive external table backed by Json |
|---|---|---|
| ansidate (ingres) | null=1 | date |
| ansidate | null=1 | date |
| bfile | null=1 | string |
| bigint unsigned |
bytelen=8
null=1 | decimal(20) |
| bigint |
bytelen=8
null=1 | bigint |
| binary |
bytelen=10
null=1 | char(2) |
| binary_double |
bytelen=8
null=1 | double |
| binary_float |
bytelen=4
null=1 | float |
| bit (mysql) |
bitlen=32
null=1 | varchar(32) |
| bit |
bytelen=1
null=1 | boolean |
| blob | null=1 | string |
| bool |
bytelen=1
null=1 | boolean |
| boolean |
bytelen=1
null=1 | boolean |
| byte varying |
bytelen=10
null=1 | string |
| byte |
bytelen=10
null=1 | char(2) |
| byteint |
bytelen=1
null=1 | smallint |
| c |
bytelen=10
encoding=UTF-8 null=1 | char(10) |
| char |
bytelen=10
encoding=UTF-8 null=1 | char(10) |
| char |
bytelen=4000
encoding=UTF-8 null=1 | varchar(4000) |
| char |
bytelen=8000
encoding=UTF-8 null=1 | varchar(8000) |
| char |
bytelen=40
charlen=10 encoding=UTF-8 null=1 | char(10) |
| char |
bytelen=10
encoding=WINDOWS-1252 null=1 | char(10) |
| char (oracle) |
bytelen=10
encoding=UTF-8 null=1 | char(10) |
| char (oracle) |
bytelen=2000
encoding=UTF-8 null=1 | varchar(2000) |
| char (oracle) |
bytelen=40
charlen=10 encoding=UTF-8 null=1 | char(10) |
| char (oracle) |
bytelen=10
encoding=WINDOWS-1252 null=1 | char(10) |
| clob |
encoding=UTF-8
null=1 | string |
| date | null=1 | timestamp |
| date (hana) | null=1 | date |
| date (mysql) | null=1 | date |
| date (sybase) | null=1 | date |
| datetime (bigquery) |
prec_sec=0
null=1 | timestamp |
| datetime (mysql) |
prec_sec=0
null=1 | timestamp |
| datetime (sybase) | null=1 | timestamp |
| datetime | null=1 | timestamp |
| datetime2 |
prec_sec=0
null=1 | timestamp |
| datetimeoffset |
prec_sec=0
null=1 | timestamp |
| db2 timestamp with time zone |
prec_sec=0
null=1 | timestamp |
| db2 xml |
encoding=UTF-8
null=1 | string |
| dbclob |
charlen=0
null=1 | string |
| decfloat |
prec=16
null=1 | varchar(42) |
| decfloat |
prec=34
null=1 | varchar(42) |
| decimal |
prec=10
scale=3 null=1 | decimal(10,3) |
| decimal |
prec=6
null=1 | decimal(6) |
| double |
bytelen=8
null=1 | double |
| epoch |
prec_sec=0
null=1 | timestamp |
| float |
bytelen=8
null=1 | double |
| float4 |
bytelen=4
null=1 | float |
| float8 |
bytelen=8
null=1 | double |
| float64 |
bytelen=8
null=1 | double |
| graphic |
charlen=10
null=1 | char(10) |
| image | null=1 | string |
| image (sybase) | null=1 | string |
| ingresdate | null=1 | timestamp |
| int unsigned |
bytelen=4
null=1 | bigint |
| int |
bytelen=4
null=1 | int |
| integer |
bytelen=4
null=1 | int |
| integer1 |
bytelen=1
null=1 | smallint |
| integer2 |
bytelen=2
null=1 | smallint |
| integer4 |
bytelen=4
null=1 | int |
| integer8 |
bytelen=8
null=1 | bigint |
| int64 |
bytelen=8
null=1 | bigint |
| interval day to second (ingres) |
prec_sec=0
null=1 | varchar(100) |
| interval day to second |
prec_sec=0
prec_day=0 null=1 | varchar(100) |
| interval month to second |
prec_sec=0
null=1 | varchar(100) |
| interval year to month (ingres) | null=1 | varchar(100) |
| interval year to month |
prec_year=0
null=1 | varchar(100) |
| json | null=1 | string |
| jsonb | null=1 | string |
| long byte | null=1 | string |
| long char |
encoding=UTF-8
null=1 | string |
| long nvarchar (db2) |
charlen=0
null=1 | string |
| long nvarchar |
charlen=0
null=1 | string |
| long raw | null=1 | string |
| long varbinary | null=1 | string |
| long varchar (db2) |
encoding=UTF-8
null=1 | string |
| long varchar |
encoding=UTF-8
null=1 | string |
| long |
encoding=UTF-8
null=1 | string |
| mediumint unsigned |
bytelen=3
null=1 | int |
| mediumint |
bytelen=3
null=1 | int |
| money (ingres) | null=1 | decimal(14,2) |
| money | null=1 | decimal(19,4) |
| nchar |
charlen=10
null=1 | char(10) |
| nchar (oracle) |
bytelen=20
charlen=10 null=1 | char(10) |
| nclob |
charlen=0
null=1 | string |
| ntext |
charlen=0
null=1 | string |
| number |
scale=0
null=1 | decimal(38,4) |
| number |
prec=10
scale=-127 null=1 | double |
| number |
prec=10
scale=3 null=1 | decimal(10,3) |
| number |
prec=26
scale=0 null=1 | decimal(26) |
| number |
prec=6
scale=0 null=1 | int |
| 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) |
| nvarchar(max) |
charlen=0
null=1 | string |
| nvarchar2 |
charlen=10
null=1 | varchar(10) |
| postgres date | null=1 | date |
| postgres timestamp with time zone |
prec_sec=0
null=1 | timestamp |
| postgres timestamp |
prec_sec=0
null=1 | timestamp |
| raw |
bytelen=10
null=1 | string |
| real |
bytelen=4
null=1 | float |
| rowid |
bytelen=18
charlen=18 encoding=US-ASCII null=1 | char(18) |
| rowversion |
bytelen=10
null=1 | char(2) |
| smalldatetime | null=1 | timestamp |
| smallint unsigned |
bytelen=2
null=1 | int |
| smallint |
bytelen=2
null=1 | smallint |
| smallmoney | null=1 | decimal(10,4) |
| text (ingres) |
bytelen=10
encoding=UTF-8 null=1 | varchar(10) |
| text (sqlserver) |
encoding=WINDOWS-1252
null=1 | string |
| text(sybase) |
encoding=UTF-8
null=1 | string |
| time (mysql) |
prec_sec=0
null=1 | varchar(25) |
| time (hana) | null=1 | varchar(25) |
| time (sybase) | null=1 | varchar(25) |
| time with local time zone |
prec_sec=0
null=1 | varchar(25) |
| time with time zone |
prec_sec=0
null=1 | varchar(25) |
| time |
prec_sec=0
null=1 | varchar(25) |
| time |
prec_sec=3
null=1 | varchar(25) |
| time2 | null=1 | varchar(25) |
| timestamp (bigquery) |
prec_sec=0
null=1 | timestamp |
| timestamp (db2) |
prec_sec=0
null=1 | timestamp |
| timestamp (hana) |
prec_sec=0
null=1 | timestamp |
| timestamp (ingres) |
prec_sec=0
null=1 | timestamp |
| timestamp (mysql) |
prec_sec=0
null=1 | timestamp |
| timestamp (oracle) |
prec_sec=0
null=1 | timestamp |
| timestamp (sqlserver) |
bytelen=10
null=1 | char(2) |
| timestamp (sybase) |
bytelen=10
null=1 | string |
| timestamp with local time zone |
prec_sec=0
null=1 | timestamp |
| timestamp with local tz (oracle) |
prec_sec=0
null=1 | timestamp |
| timestamp with time zone |
prec_sec=0
null=1 | timestamp |
| timestamp with tz (oracle) |
prec_sec=0
null=1 | timestamp |
| timestamp |
prec_sec=0
null=1 | timestamp |
| tinyint signed |
bytelen=1
null=1 | smallint |
| tinyint unsigned |
bytelen=1
null=1 | smallint |
| tinyint |
bytelen=1
null=1 | smallint |
| uniqueidentifier |
bytelen=16
null=1 | char(36) |
| unitext |
charlen=0
null=1 | string |
| univarchar |
charlen=10
null=1 | varchar(10) |
| unsigned bigint |
bytelen=8
null=1 | decimal(20) |
| unsigned int |
bytelen=4
null=1 | bigint |
| unsigned smallint |
bytelen=2
null=1 | int |
| urowid |
bytelen=100
charlen=100 encoding=US-ASCII null=1 | varchar(100) |
| varbinary |
bytelen=10
null=1 | string |
| varbinary (sybase) |
bytelen=10
null=1 | string |
| varbinary(max) | null=1 | string |
| varbyte |
bytelen=10
null=1 | string |
| varchar |
bytelen=10
encoding=UTF-8 null=1 | varchar(10) |
| varchar |
bytelen=8000
encoding=UTF-8 null=1 | varchar(8000) |
| varchar |
bytelen=40
charlen=10 encoding=UTF-8 null=1 | varchar(10) |
| varchar |
bytelen=10
encoding=WINDOWS-1252 null=1 | varchar(10) |
| varchar (sybase) |
bytelen=10
encoding=UTF-8 null=1 | varchar(10) |
| varchar (sybase) |
bytelen=8000
encoding=UTF-8 null=1 | varchar(8000) |
| varchar (sybase) |
bytelen=40
charlen=10 encoding=UTF-8 null=1 | varchar(10) |
| varchar (sybase) |
bytelen=10
encoding=WINDOWS-1252 null=1 | varchar(10) |
| varchar(max) |
encoding=WINDOWS-1252
null=1 | string |
| varchar2 |
bytelen=10
encoding=UTF-8 null=1 | varchar(10) |
| varchar2 |
bytelen=40
charlen=10 encoding=UTF-8 null=1 | varchar(10) |
| varchar2 |
bytelen=10
encoding=WINDOWS-1252 null=1 | varchar(10) |
| vargraphic |
charlen=10
null=1 | varchar(10) |
| xml |
charlen=0
null=1 | string |
| year (mysql) | null=1 | smallint |
Hive External Tables with Parquet as Target
In a target location with Hive External Tables, when the file type is Parquet, following is the mapping of HVR repository data types to the corresponding data type in Parquet.
Text in green cell indicates the native data type of the DBMS
| HVR Repository Data Types | Attributes | Hive external table backed by Parquet |
|---|---|---|
| ansidate (ingres) | null=1 | date |
| ansidate | null=1 | date |
| bfile | null=1 | binary |
| bigint unsigned |
bytelen=8
null=1 | decimal(20) |
| bigint |
bytelen=8
null=1 | bigint |
| binary |
bytelen=10
null=1 | binary |
| binary_double |
bytelen=8
null=1 | double |
| binary_float |
bytelen=4
null=1 | float |
| bit (mysql) |
bitlen=32
null=1 | varchar(32) |
| bit |
bytelen=1
null=1 | boolean |
| blob | null=1 | binary |
| bool |
bytelen=1
null=1 | boolean |
| boolean |
bytelen=1
null=1 | boolean |
| byte varying |
bytelen=10
null=1 | binary |
| byte |
bytelen=10
null=1 | binary |
| byteint |
bytelen=1
null=1 | smallint |
| c |
bytelen=10
encoding=UTF-8 null=1 | char(10) |
| char |
bytelen=10
encoding=UTF-8 null=1 | char(10) |
| char |
bytelen=4000
encoding=UTF-8 null=1 | varchar(4000) |
| char |
bytelen=8000
encoding=UTF-8 null=1 | varchar(8000) |
| char |
bytelen=40
charlen=10 encoding=UTF-8 null=1 | char(10) |
| char |
bytelen=10
encoding=WINDOWS-1252 null=1 | char(10) |
| char (oracle) |
bytelen=10
encoding=UTF-8 null=1 | char(10) |
| char (oracle) |
bytelen=2000
encoding=UTF-8 null=1 | varchar(2000) |
| char (oracle) |
bytelen=40
charlen=10 encoding=UTF-8 null=1 | char(10) |
| char (oracle) |
bytelen=10
encoding=WINDOWS-1252 null=1 | char(10) |
| clob |
encoding=UTF-8
null=1 | string |
| date | null=1 | timestamp |
| date (hana) | null=1 | date |
| date (mysql) | null=1 | date |
| date (sybase) | null=1 | date |
| datetime (bigquery) |
prec_sec=0
null=1 | timestamp |
| datetime (mysql) |
prec_sec=0
null=1 | timestamp |
| datetime (sybase) | null=1 | timestamp |
| datetime | null=1 | timestamp |
| datetime2 |
prec_sec=0
null=1 | timestamp |
| datetimeoffset |
prec_sec=0
null=1 | timestamp |
| db2 timestamp with time zone |
prec_sec=0
null=1 | timestamp |
| db2 xml |
encoding=UTF-8
null=1 | string |
| dbclob |
charlen=0
null=1 | string |
| decfloat |
prec=16
null=1 | varchar(42) |
| decfloat |
prec=34
null=1 | varchar(42) |
| decimal |
prec=10
scale=3 null=1 | decimal(10,3) |
| decimal |
prec=6
null=1 | decimal(6) |
| double |
bytelen=8
null=1 | double |
| epoch |
prec_sec=0
null=1 | timestamp |
| float |
bytelen=8
null=1 | double |
| float4 |
bytelen=4
null=1 | float |
| float8 |
bytelen=8
null=1 | double |
| float64 |
bytelen=8
null=1 | double |
| graphic |
charlen=10
null=1 | char(10) |
| image | null=1 | binary |
| image (sybase) | null=1 | binary |
| ingresdate | null=1 | timestamp |
| int unsigned |
bytelen=4
null=1 | bigint |
| int |
bytelen=4
null=1 | int |
| integer |
bytelen=4
null=1 | int |
| integer1 |
bytelen=1
null=1 | smallint |
| integer2 |
bytelen=2
null=1 | smallint |
| integer4 |
bytelen=4
null=1 | int |
| integer8 |
bytelen=8
null=1 | bigint |
| int64 |
bytelen=8
null=1 | bigint |
| interval day to second (ingres) |
prec_sec=0
null=1 | varchar(100) |
| interval day to second |
prec_sec=0
prec_day=0 null=1 | varchar(100) |
| interval month to second |
prec_sec=0
null=1 | varchar(100) |
| interval year to month (ingres) | null=1 | varchar(100) |
| interval year to month |
prec_year=0
null=1 | varchar(100) |
| json | null=1 | string |
| jsonb | null=1 | string |
| long byte | null=1 | binary |
| long char |
encoding=UTF-8
null=1 | string |
| long nvarchar (db2) |
charlen=0
null=1 | string |
| long nvarchar |
charlen=0
null=1 | string |
| long raw | null=1 | binary |
| long varbinary | null=1 | binary |
| long varchar (db2) |
encoding=UTF-8
null=1 | string |
| long varchar |
encoding=UTF-8
null=1 | string |
| long |
encoding=UTF-8
null=1 | string |
| mediumint unsigned |
bytelen=3
null=1 | int |
| mediumint |
bytelen=3
null=1 | int |
| money (ingres) | null=1 | decimal(14,2) |
| money | null=1 | decimal(19,4) |
| nchar |
charlen=10
null=1 | char(10) |
| nchar (oracle) |
bytelen=20
charlen=10 null=1 | char(10) |
| nclob |
charlen=0
null=1 | string |
| ntext |
charlen=0
null=1 | string |
| number |
scale=0
null=1 | decimal(38,4) |
| number |
prec=10
scale=-127 null=1 | double |
| number |
prec=10
scale=3 null=1 | decimal(10,3) |
| number |
prec=26
scale=0 null=1 | decimal(26) |
| number |
prec=6
scale=0 null=1 | int |
| 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) |
| nvarchar(max) |
charlen=0
null=1 | string |
| nvarchar2 |
charlen=10
null=1 | varchar(10) |
| postgres date | null=1 | date |
| postgres timestamp with time zone |
prec_sec=0
null=1 | timestamp |
| postgres timestamp |
prec_sec=0
null=1 | timestamp |
| raw |
bytelen=10
null=1 | binary |
| real |
bytelen=4
null=1 | float |
| rowid |
bytelen=18
charlen=18 encoding=US-ASCII null=1 | char(18) |
| rowversion |
bytelen=10
null=1 | binary |
| smalldatetime | null=1 | timestamp |
| smallint unsigned |
bytelen=2
null=1 | int |
| smallint |
bytelen=2
null=1 | smallint |
| smallmoney | null=1 | decimal(10,4) |
| text (ingres) |
bytelen=10
encoding=UTF-8 null=1 | varchar(10) |
| text (sqlserver) |
encoding=WINDOWS-1252
null=1 | string |
| text(sybase) |
encoding=UTF-8
null=1 | string |
| time (mysql) |
prec_sec=0
null=1 | varchar(25) |
| time (hana) | null=1 | varchar(25) |
| time (sybase) | null=1 | varchar(25) |
| time with local time zone |
prec_sec=0
null=1 | varchar(25) |
| time with time zone |
prec_sec=0
null=1 | varchar(25) |
| time |
prec_sec=0
null=1 | varchar(25) |
| time |
prec_sec=3
null=1 | varchar(25) |
| time2 | null=1 | varchar(25) |
| timestamp (bigquery) |
prec_sec=0
null=1 | timestamp |
| timestamp (db2) |
prec_sec=0
null=1 | timestamp |
| timestamp (hana) |
prec_sec=0
null=1 | timestamp |
| timestamp (ingres) |
prec_sec=0
null=1 | timestamp |
| timestamp (mysql) |
prec_sec=0
null=1 | timestamp |
| timestamp (oracle) |
prec_sec=0
null=1 | timestamp |
| timestamp (sqlserver) |
bytelen=10
null=1 | binary |
| timestamp (sybase) |
bytelen=10
null=1 | binary |
| timestamp with local time zone |
prec_sec=0
null=1 | timestamp |
| timestamp with local tz (oracle) |
prec_sec=0
null=1 | timestamp |
| timestamp with time zone |
prec_sec=0
null=1 | timestamp |
| timestamp with tz (oracle) |
prec_sec=0
null=1 | timestamp |
| timestamp |
prec_sec=0
null=1 | timestamp |
| tinyint signed |
bytelen=1
null=1 | smallint |
| tinyint unsigned |
bytelen=1
null=1 | smallint |
| tinyint |
bytelen=1
null=1 | smallint |
| uniqueidentifier |
bytelen=16
null=1 | char(36) |
| unitext |
charlen=0
null=1 | string |
| univarchar |
charlen=10
null=1 | varchar(10) |
| unsigned bigint |
bytelen=8
null=1 | decimal(20) |
| unsigned int |
bytelen=4
null=1 | bigint |
| unsigned smallint |
bytelen=2
null=1 | int |
| urowid |
bytelen=100
charlen=100 encoding=US-ASCII null=1 | varchar(100) |
| varbinary |
bytelen=10
null=1 | binary |
| varbinary (sybase) |
bytelen=10
null=1 | binary |
| varbinary(max) | null=1 | binary |
| varbyte |
bytelen=10
null=1 | binary |
| varchar |
bytelen=10
encoding=UTF-8 null=1 | varchar(10) |
| varchar |
bytelen=8000
encoding=UTF-8 null=1 | varchar(8000) |
| varchar |
bytelen=40
charlen=10 encoding=UTF-8 null=1 | varchar(10) |
| varchar |
bytelen=10
encoding=WINDOWS-1252 null=1 | varchar(10) |
| varchar (sybase) |
bytelen=10
encoding=UTF-8 null=1 | varchar(10) |
| varchar (sybase) |
bytelen=8000
encoding=UTF-8 null=1 | varchar(8000) |
| varchar (sybase) |
bytelen=40
charlen=10 encoding=UTF-8 null=1 | varchar(10) |
| varchar (sybase) |
bytelen=10
encoding=WINDOWS-1252 null=1 | varchar(10) |
| varchar(max) |
encoding=WINDOWS-1252
null=1 | string |
| varchar2 |
bytelen=10
encoding=UTF-8 null=1 | varchar(10) |
| varchar2 |
bytelen=40
charlen=10 encoding=UTF-8 null=1 | varchar(10) |
| varchar2 |
bytelen=10
encoding=WINDOWS-1252 null=1 | varchar(10) |
| vargraphic |
charlen=10
null=1 | varchar(10) |
| xml |
charlen=0
null=1 | string |
| year (mysql) | null=1 | smallint |