How to connect to Hive server on VMware from Tableau on my desktop?

This is my first time using Tableau to talk to a Hadoop data source.

My computer configuration:

Desktop: Win7+Tableau9.3.5, 192.168.2.20

Hadoop 2.7.2 + Hive 2.0 on CentOS7 on VMware (same machine with Win7) 192.168.112.150

I can ping from my desktop to the Hive server which is on a node on VMware.

In my Tableau on my desktop, I set the data source as HiverServer2 where I provided the credential.

I was declined access with an error below:

Can anyone help me sort it out?

Thank you very much.

Answers


Make sure you have the latest Hive ODBC connector installed and configured with the updated CA Certification PEM file (cacerts.pem file).


Need Your Help

How to organize data of several datasets into the same dataframe using pandas in Python?

python pandas indexing dataframe multi-index

I am having trouble in keeping some data organized as I want in a data frame using pandas in Python.

Swift 3 and Xcode8 - Ambiguous use of init

ios swift xcode swift3 xcode8

Before I installed Xcode 8 and converted project to Swift 3, the following line was fine. Now after conversion it looks like this: