Data Types
- Last Updated:Jun 13, 2020
- 1 minute read
- DataDirect Connectors
- JDBC
- Cloudera Impala 5.1
- Documentation
The following table shows how the Impala data types are mapped to the standard JDBC data types.
Impala | JDBC |
---|---|
Bigint | BIGINT |
Boolean | BOOLEAN |
Char1 | CHAR |
Decimal2 | DECIMAL |
Double | DOUBLE |
Float | REAL |
Int | INTEGER |
Smallint | SMALLINT |
String3 | VARCHAR or LONGVARCHAR4 |
Timestamp | TIMESTAMP |
Tinyint | TINYINT |
Varchar5 | VARCHAR |
1 Supported for Cloudera Impala 2.1 and higher.
2 Supported for Cloudera Impala 1.4 and higher.
3 Maximum of 2 GB
4 If the StringDescribeType connection property is set
to
varchar
(the default), the String data type maps
to VARCHAR. If StringDescribeType is set to longvarchar
, String maps to LONGVARCHAR.5 Supported for Cloudera Impala 2.1 and higher.