skip to main content
About the Apache Hive Driver : Data Types
  

Try DataDirect Drivers Now

Data Types

The following table shows how the Apache Hive data types are mapped to the standard ODBC data types.
Table 1. Apache Hive Data Types
Apache Hive
ODBC
Bigint
SQL_BIGINT
Boolean
SQL_BIT
Char
SQL_CHAR
Date
SQL_DATE
Decimal
SQL_DECIMAL
Double
SQL_DOUBLE
Float
SQL_REAL
Int
SQL_INTEGER
Smallint
SQL_SMALLINT
String1
SQL_WVARCHAR2
Timestamp
SQL_TYPE_TIMESTAMP
Tinyint
SQL_TINYINT
Varchar
SQL_VARCHAR
1 The StringDescribeType connection option setting determines where this data type maps. For example, if set to -9 (SQL_WVARCHAR), the default, this data type maps to SQL_WVARCHAR.

2 Maximum of 2 GB

* Retrieving Data Type Information