cancel
Showing results for 
Search instead for 
Did you mean: 

Connect to Hive in Azure HDInsight

Alteryx
Alteryx

This solution uses the Simba ODBC Hive Driver version

The driver can be downloaded from the Alteryx Driver Download Page

Configure the Hive ODBC Driver

 

Property

Description

Data Source Name

Give a name to your data source

Host

Enter <HDInsightClusterName>.azurehdinsight.net. For example, myHDICluster.azurehdinsight.net

Port

Use 443

Database

Use Default

Hive Server Type

Select Hive Server 2

Mechanism

Select Windows Azure HDInsight Service

User Name

Enter HDInsight cluster HTTP user username. The default username is admin

Password

Enter HDInsight cluster user password

Contributors