|Type of Support:||Read & Write; In-Database|
Hive 2.0; Simba Hive driver 18.104.22.1680
Cloudera ODBC driver 22.214.171.1240
|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
- Input Data Tool and Output Data Tool (For standard workflow processing)
- Connect In-DB Tool and Data Stream In Tool (For In-Database workflow processing).
Hive does not properly handle writing multi-byte characters in wide strings (WStrings). For more information, see the Unicode® character SQL INSERT issue.