Data Types
- Last Updated: May 15, 2020
- 1 minute read
- DataDirect Connectors
- JDBC
- IBM Db2 5.1
- MySQL 5.1
- Progress OpenEdge 5.1
- SAP Sybase 5.1
- Documentation
The following table shows how the Apache Hive data types are mapped to the standard JDBC data types.
| Apache Hive | JDBC |
|---|---|
| Bigint | BIGINT |
| Binary 1 | VARBINARY |
| Boolean | BOOLEAN |
| Char 2 | CHAR |
| Date3 | DATE |
| Decimal 4 | DECIMAL |
| Double | DOUBLE |
| Float | REAL |
| Int | INTEGER |
| Smallint | SMALLINT |
| String 5 | VARCHAR or LONGVARCHAR 6 |
| Timestamp | TIMESTAMP |
| Tinyint | TINYINT |
| Varchar7 | VARCHAR |
1 Supported only with HiveServer1.
2 Supported for Apache Hive 0.13 and
higher.
3 Supported for Apache Hive 0.12 and higher.
4 For Apache Hive 0.13 and higher, supported as a
user-defined, variable precision data type. For Apache Hive 0.11 and 0.12, supported
as a fixed precision data type.
5 Maximum of 2 GB
6 If the StringDescribeType property is set to
varchar (the default), this data type maps to
VARCHAR. If set to longvarchar, this data type maps
to LONGVARCHAR.7 Supported for Apache
Hive 0.12 and higher.