Apache Hive
| Connection Type | ODBC (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
For more information about the Simba Hive ODBC driver, go to the Installation and Configuration Guide on the Simba portal.
Alteryx Tools Used to Connect
Standard Workflow Processing
In-Database Workflow Processing
Additional Details
The Use Native Query option in the Simba Hive ODBC driver is not supported for Write InDB or Data Stream in InDB.
Hive does not properly handle writing multibyte characters in wide strings (WStrings). For more information, go to 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.
The Create New Table option in the Output tool creates a managed table in Hive.