Hive - Project - Sentiment Analysis - Visualization


#1

I am unable to connect to database in tableau using my labusername, can you please help with the same.
This is the Hive - Iron Man movie - Sentiment Visualisation lab


#2

Hi, Shruti.
Kindly follow the below Workflow and you should be able to complete the project.

Downloads:-

  1. https://www.tableau.com/pro
  2. https://www.cloudera.com/do
    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 Tableau 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 :- Tablaue supported Drivers page.
This will show all the Drivers that Tablue supports.
Again it will take to the site :- cloudera downloads page

All the best.