Connecting tableau to cloudera hive

[#1]

Hi, I am trying to connect tableau to hadoop but i am facing the following error. could someone suggest how to resolve the issue please.

error as follows:

Unable to connect to the ODBC Data Source. Check that the necessary drivers are installed and that the connection properties are valid.
[Cloudera][Hardy] (34) Error from server: connect() failed: errno = 10060.
Unable to connect to the server "10.0.2.15". Check that the server is running and that you have access privileges to the requested database.

[#2]

Hello HN,

Do you have the Hive ODBC driver installed for tableau?

Please also check that the configured IP address is points to a HiveServer2 instance, and the required ports on that ip is reachable from the tableau node.

Zsolt

[#3]

Hi,

Thanks for the revert. Yes, latest Hive odbcdriver is installed.

1- IP address - i got it by checking ifconfig.

2 - port for hiveserver2 is10000 which i have given.

but still it does not connect.

Also when i run hive --service hiveserver2 in the terminal it it gives the following message - hive cli is deprecated and migration to beeline is recommended.

I am not sure what to do.

Regards,

anil HN

[#4 · Accepted solution]

Hi,

Can you check if the port is reachable from the Tableau computer? You might have a firewall or other network restriction in between.

For beeline migration, you can check our blogpost:
https://blog.cloudera.com/blog/2014/02/migrating-from-hive-cli-to-beeline-a-primer/

You may use beeline on the computer tableau is installed, to verify if hive is reachable.

[#5]

Hi,

sry i was out of station and could not reply back.

Yes, I got to cnnect to tableau after resolving the firewall issue. we need to make the port reachable.

thanks a lot.

regards,

Anil HN

[#6]

Hello,

How are you able to resolve the firewall issue, can you tell me the steps you followed to make the port reachable.Can you please elaborate.

Thanks in advance.

[#7]

@HN Hi guys, i had same issue so I got it fixed by following the step 3 (Configuration of the ODBC Driver) from this website (https://towardsdatascience.com/connecting-apache-hive-to-microsoft-power-bi-d460e2278720). It usually shows how to connect to Power BI but the configuration part is same for tableau as well. Hope it helps.😊