The following table shows how the Impala data types are mapped to the standard JDBC data types.

Table 1. Impala 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.