Hive

Version:
2019.3
Last modified: September 24, 2019
Connection Type

ODBC (32- and 64-bit)

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.

Driver Details

The Simba ODBC driver can be downloaded here.

In-Database processing requires 64-bit database drivers.

Type of Support

Read & Write; In-Database

Validated On

Hive 2.0; Simba Hive Driver 2.1.14.1020

Alteryx tools used to connect

Standard workflow processing

In-Database workflow processing

Link
Blue icon with database being plugged in.

Connect In-DB Tool

Link
Blue icon with a stream-like object flowing into a database.

Data Stream In Tool

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.

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.

Was This Helpful?

Need something else? Visit the Alteryx Community or contact support.