Part 4: The Connect XE Drivers
:
The Impala Wire Protocol Driver
:
Data Types
Data Types
The following table shows how the Impala data types are mapped to the standard ODBC data types.
Table 69.
Impala Data Types
Impala
ODBC
Bigint
SQL_BIGINT
Boolean
SQL_BIT
Char
1
SQL_CHAR
Double
SQL_DOUBLE
Float
SQL_REAL
Int
SQL_INTEGER
Smallint
SQL_SMALLINT
String
2
SQL_WVARCHAR,
SQL_WLONGVARCHAR
3
Timestamp
SQL_TYPE_TIMESTAMP
Tinyint
SQL_TINYINT
Varchar
4
SQL_VARCHAR
1
Supported with Impala 2.0 and higher.
2
Maximum of 2 GB
3
If the StringDescribeType property is set to
wvarchar
(the default), this data type maps to
WVARCHAR
. If set to
wlongvarchar
, this data type maps to
WLONGVARCHAR
.
4
Supported with Impala 2.0 and higher.