Apache Hive
Version:
Current
Last modified: February 23, 2021
| Connection Type | ODBC (32- and 64-bit) |
| 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. |
| Type of Support | Read & Write, In-Database |
| Validated On | Database Version: 3.1.0.3.0.1.0-187 |
Driver Details
The In-Database process requires 64-bit database drivers.
For more information about the Simba Hive ODBC driver, see the Installation and Configuration Guide on Simba portal.
Alteryx Tools Used to Connect
Standard Workflow Processing
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.
If you have issues with reading or writing Unicode® characters, access the Simba Impala ODBC driver. Under Advanced Options, select the "Use SQL Unicode Types" option.