Hive

 

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