Tableau issue while accessing Hive


#1

Hi Cloudxlab Team

Am not able to connect to Hive using Tableau.

Here is error

An error occurred while communicating with Hortonworks Hadoop Hive.

Unable to connect to the server. Check that the server is running and that you have access privileges to the requested database.
Error Code: 37CE01A3
There was an unknown connection error to the database. The error message below has additional information, but you might need to ask the database administrator to review the database logs.
[Hortonworks][DriverSupport] (1110) Unexpected response received from server. Please ensure the server host and port specified for the connection are correct and confirm if SSL should be enabled for the connection.
Unable to connect to the Hortonworks Hadoop Hive server ‘c.cloudxlab.com’. Check that the server is running and that you have access privileges to the requested database.

Could you please help in resolving issue.

Thanks and regards
Sayeef


#2

Hi, Sayeef.
I have rechecked the server is running properly, can you follow the steps again? you should be able to do it. If still you get any issue please reply to this thread.

Downloads:-

  1. https://www.tableau.com/products/desktop
  2. https://www.cloudera.com/downloads/
    a) Go down find database driver
    b) Select Hive ODBC Driver Downloads
    c) Select Hive ODBC 2.6.1 (It is a stable version). Select
    d) Select OS and version 64 bit.

Workflow for connecting Tablue to CloudexLab Local user via ODBC Driver.

  1. Open tableau ( Now they are giving 14 days trial).
  2. Go to > To a Server > Hortonworks Hadoop Hive.
  3. Enter c.cloudxlab.com as Server and port as 10000
  4. Select “Username and Password” as Authentication.
  5. Enter your lab username and password.
  6. Select “SASL” as Transport.
    Click on “Sign in” and wait for the connection to establish.

Note :- we can downloads the ODBC Driver from here also.
a) At the left down corner. It will show “Downlaods and Install the drivers” if your driver is not insatlled.
b) If you click It will take you the page :- https://www.tableau.com/en-us/support/drivers?edition=pro&lang=en-us&platform=windows&cpu=64&version=2019.3&__full-version=20193.19.0821.2225#
This will show all the Drivers that Tablue supports.
Again it will take to the site :- https://www.cloudera.com/downloads/

All the best.