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

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.