[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 the one-year free license. After the download is finished, install the Tableau desktop.
We will connect to Hive using Hive ODBC driver. Download Hortonworks Hive ODBC driver for your operating system using the link displayed on the screen. After the download is finished, install it.
[Hive - Connecting to Tableau - Hands-on]
Let's use tableau. Visualize top 10 stocks with highest opening price on Dec 31, 2009
Now, we will visualize sentiments of each country for "Iron Man 3" movie. We'll use tweetsbi table in Hive. If you haven't gone through "Connect To Apache Hive Using Tableau" topic, please see the first video.
We'll visualize the sentiments in China, Mexico and the United States. 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 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 search on the map tool bar 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 - For connecting to Hive, please select transport as SASL in Tableau