skip to main content
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
Double
SQL_DOUBLE
Float
SQL_REAL
Int
SQL_INTEGER
Smallint
SQL_SMALLINT
String1
SQL_WVARCHAR,
SQL_WLONGVARCHAR
Timestamp
SQL_TYPE_TIMESTAMP
Tinyint
SQL_TINYINT
1 Maximum of 2 GB

2 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.