skip to main content
Welcome to the Progress DataDirect Connect XE for JDBC for Impala Driver : Data Types
  

Try DataDirect Drivers Now

Data Types

The following table shows how the Impala data types are mapped to the standard JDBC data types.
Table 3. 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.

* getTypeInfo