Data Types
- Last Updated: October 3, 2020
- 1 minute read
- DataDirect Connectors
- ODBC
- Cloudera Impala 7.1
- dBase 7.1
- Flat files/Text 7.1
- MySQL 7.1
- Pervasive (Btrieve) 7.1
- XML 7.1
- Documentation
The following table shows how the Impala data types are mapped to the standard ODBC data types.
| Impala | ODBC |
|---|---|
| Bigint | SQL_BIGINT |
| Boolean | SQL_BIT |
| Char1 | SQL_CHAR |
| Decimal2 | SQL_DECIMAL |
| Double | SQL_DOUBLE |
| Float | SQL_REAL |
| Int | SQL_INTEGER |
| Smallint | SQL_SMALLINT |
| String3 | SQL_WVARCHAR, SQL_WLONGVARCHAR 4 |
| Timestamp | SQL_TYPE_TIMESTAMP |
| Tinyint | SQL_TINYINT |
| Varchar5 | SQL_VARCHAR |
1 Supported with Impala 2.0 and higher.
2 Supported with Impala 2.0 and higher.
3 Maximum of 2 GB
4 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.5 Supported with Impala 2.0 and higher.