Apache Hive

Version:
Current
Last modified: October 19, 2020
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.
Type of Support

Read & Write, In-Database
Validated On

Hive 2.0
Simba Hive Driver 2.6
ODBC Client Version 3.1.0.3.0.1.0 -187

Driver Details

The In-Database process requires 64-bit database drivers.
Certified SIMBA driver from Alteryx Download Center

Alteryx Tools Used to Connect

Standard Workflow Processing

Link
Input Data Tool Icon

Input Data Tool

Link
Output Data Tool Icon

Output Data Tool

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?

Running into problems or issues with your Alteryx product? Visit the Alteryx Community or contact support.