Hive with Tableau via Microsoft Hive ODBC Driver

Question

Hi,

I want to establish connection between Hive an d Tableau via Microsoft Hive ODBC Driver But I am getting following error:

---

manisha

Answer 1

Hi Manisha,

To connect HDInsight Hive server with Tableau, follow the below steps:

1.You need to download and install the Hive ODBC driver.

2.Open ODBC Data Sources (32/64 bit) => Go to System DSN => Click on Add.

Enter the below details as follows:

Hosts: azurewala.azurehdinsight.net

Port: 443

Mechanism: Windows Azure HDInsight Service

Username: admin

Password: ***********

Thrift Transport: HTTP

After entering the details, click on test and OK.

3.Open Tableau => To a Server => More… => Select “Hortonworks Hadoop Hive”

4. Enter the details as shown below.

Server: HDInsight cluster URL.: azurewala.azurehdinsight.net

Port: 443

Authentication: Microsoft Azure HDInsight Service

Username and Password: Cluster credentials.

And entering the details, click on Sign In

Processing Request……..Connecting to data source……Connected.

Hope this helps.

Answer 2

Hi,

Thanks for reply.

I am using Hortonworks Hive ODBC driver instead of Microsoft Hive ODBC Driver. Followed the below steps as you did

After clicking OK I opened Tableau and do the same setting as you did, but getting error

Here I selected Authentication option as Username and Password

---

manisha

Answer 3

Hi Manisha,

It recommends using “Hive ODBC driver” to connect Azure HDInsight Hive server with Tableau.

I would suggest you try the above mentioned steps to connect Azure HDInsight Hive server with Tableau.

Answer 4

Just checking in to see if the above answer helped. If this answers your query, do click “Mark as Answer” and Up-Vote for the same. And, if you have any further query do let us know.

Answer 5

Hi,

Thanks for reply.

The issue was resolved after registering Port on Azure Hortonworks cluster master node for ODBC connection. Port was not registered on Azure that's the reason I was not able to connect. Now its working fine.

---

manisha

Answer 6

Hi Manisha,

Thank you for sharing your solution and experience here. It will be greatly beneficial for other community members who have similar questions.