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