Hive
| Type of Support: | Read & Write; In-Database |
| Validated On: |
Hive 2.0; Simba Hive driver 2.1.14.1020 Cloudera ODBC driver 2.5.25.1020 |
| Connection Type: | ODBC (32- and 64-bit) |
| Driver Details: | The Simba ODBC driver can be downloaded here. In-Database processing requires 64-bit database drivers.
The Cloudera ODBC driver can be downloaded here. |
| Driver Configuration Requirements: | For optimal performance, you must enable the "FastSQLPrepare" option within the driver to allow Alteryx to retrieve metadata without running a query. |
Alteryx tools used to connect
- Input Data Tool and Output Data Tool (For standard workflow processing)
- Connect In-DB Tool and Data Stream In Tool (For In-Database workflow processing).
Additional Details
Hive does not properly handle writing multi-byte characters in wide strings (WStrings). For more information, see the Unicode® character SQL INSERT issue.