skip to main content
Part 4: The Connect XE Drivers : The Driver for Apache Hive : Data Types
  
Data Types
The following table shows how the Apache Hive data types are mapped to the standard ODBC data types.
Table 84. Apache Hive Data Types
Apache Hive
ODBC
Bigint
SQL_BIGINT
Binary1
SQL_VARBINARY
Boolean
SQL_BIT
Double
SQL_DOUBLE
Float
SQL_REAL
Int
SQL_INTEGER
Smallint
SQL_SMALLINT
String2
SQL_VARCHAR3
Timestamp4
SQL_TYPE_TIMESTAMP
Tinyint
SQL_TINYINT
1 Supported only with Apache Hive 0.8.1 and higher.

2 The StringDescribeType connection option setting determines where this data type maps. For example, if set to sql_varchar (the default), this data type maps to SQL_VARCHAR

3 Maximum of 2 GB

4 Supported only with Apache Hive 0.8.0 and higher.