ODBC (32- and 64-bit)
The ODBC driver can be downloaded here. Certified with CDH 5.8.
In-Database processing requires 64-bit database drivers.
|Type of Support||
Read & Write; In-Database
Impala 2.6.0; Simba Impala Driver 126.96.36.1996
Alteryx tools used to connect
Standard workflow processing
- To write a table with field names that total more than 4000 characters, use CSV instead of Avro.
- When creating field names and writing queries in Impala, note that identifiers (names of databases, tables or columns) in Impala have certain restrictions. While reserved keywords are supported, other identifiers are not supported. For example:
- Identifiers cannot have a space.
- Identifiers cannot begin with a number (e.g., 1st is invalid)
- Identifiers can only be alphanumeric (e.g., no percent sign (tax%), dollar sign (money$), symbols (>, < etc) or any other non-ASCII characters.
- Identifiers are case insensitive (e.g., T1 and t1 are the same identifier)
- Quoted fields in table styles are not supported.
- Unicode® characters are not supported.
Delete and Append statements are not supported.
- Strings are limited to 32,767 bytes.
- The TINYINT data type range is -128 to 127 and therefore needs to be mapped to INT16.