Apache Hive

Version:
2022.1
Last modified: August 24, 2022
Connection Type

ODBC (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

Database Version: 3.1.0.3.0.1.0-187
ODBC Client Version: 2.06.10.1010

For more information about the Simba Hive ODBC driver, go to the Installation and Configuration Guide on the Simba portal.

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

The Use Native Query option in the Simba Hive ODBC driver is not supported for Write InDB or Data Stream in InDB.

Hive does not properly handle writing multibyte characters in wide strings (WStrings). For more information, go to 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.

The Create New Table option in the Output tool creates a managed table in Hive.

Was This Page Helpful?

Running into problems or issues with your Alteryx product? Visit the Alteryx Community or contact support. Can't submit this form? Email us.