Type of Support: Read & Write; In-Database
Validated On: Hive 2.0; Simba Hive Driver
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.

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:

Additional Details

Hive does not properly handle writing multi-byte characters in wide strings (WStrings). For more information, see Unicode insert issue.