Hive - Project - Sentiment Analysis - Visualization

Hive - Connecting to Tableau

Tableau is a visualization tool. We can connect to Hive using Tableau and transform data stored in Hive into visually appealing and interactive visualizations.

Hive - Connecting to Tableau - Steps

Let's connect to Hive using Tableau. Download Tableau Desktop from the link displayed on the screen. Tableau is a paid software. If you are a student, you can get a one-year free license. After the download is finished, install the Tableau desktop.

We will connect to Hive using Hive ODBC driver. For windows: Download Hive ODBC Driver from here

For mac, download "Hortonworks ODBC Driver for Apache Hive" -> OSX from the Cloudera Website

Hive - Connecting to Tableau - Hands-on

Let's use tableau.

• Open tableau
• Go to > To a Server > Hortonworks Hadoop Hive
• Enter c.cloudxlab.com as Server and port as 10000
• Select Username and Password as Authentication.
• Enter your lab username and password.
• Select SASL as Transport.
• Click on Sign in and wait for the connection to establish.
• Type in your database name in schema and press enter. Now select your database.
• Now, we will visualize sentiments of each country for "Iron Man 3" movie. We'll use _tweetsbi_ table in Hive.
• We'll visualize the sentiments in China, Mexico, and the United States.
• Now search for tweetsbi table under your database and select it.
• Click on sheet1. Select Country, Sentiment from dimensions and Number of records from measures and click on show me to see the recommended chart by Tableau.
• Select the recommended chart and wait for the query to get executed.
• Hide the recommended charts. As you can see, Tableau has plotted the chart with sentiments in each country.
• Each circle represents a country and each pie block in the circle shows the share of positive, negative, and neutral sentiment in that particular country.

• Click on Size and increase the size of circles.

  Please see below screencast to learn how will you visualize the data using Tableau

Now, hover on each pie block to see the sentiments in that country. As you can see, in the United States 13,235 people have a positive sentiment for the "Iron man 3" movie, 5,229 people have a negative sentiment and 25,959 people have expressed a neutral sentiment.

A majority of the people have a neutral sentiment in the United States. Let's visualize the sentiments in Mexico.

Click on the search on the map toolbar and search for Mexico. Increase the size of the circles. You can see that 628 people have a neutral sentiment, 172 people have a negative sentiment and 136 people have a positive sentiment.

Similarly, we can visualize the sentiments in China.

Note -

• You can refer to this video in order to connect Tableau to hive

• For connecting to Hive, please select transport as SASL in Tableau

• Here are some video references from our users,

  • Video reference 1
  • Video reference 2