Please see below screencast to learn how will you visualize the data using Tableau 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.Ĭlick on Size and increase the size of circles.

As you can see, Tableau has plotted the chart with sentiments in each country.

Select the recommended chart and wait for the query to get executed.

Select Country, Sentiment from dimensions and Number of records from measures and click on show me to see the recommended chart by Tableau.

Now search for tweetsbi table under your database and select it.

We'll visualize the sentiments in China, Mexico, and the United States.

Now, we will visualize sentiments of each country for 'Iron Man 3' movie.

Type in your database name in schema and press enter.

Click on Sign in and wait for the connection to establish.

Select Username and Password as Authentication.

Go to > To a Server > Hortonworks Hadoop Hive.

For windows: Download Hive ODBC Driver from hereįor mac, download 'Hortonworks ODBC Driver for Apache Hive' -> OSX from the Cloudera Website Hive - Connecting to Tableau - Hands-on We will connect to Hive using Hive ODBC driver. After the download is finished, install the Tableau desktop. If you are a student, you can get a one-year free license. Download Tableau Desktop from the link displayed on the screen. We can connect to Hive using Tableau and transform data stored in Hive into visually appealing and interactive visualizations. Hive - Project - Sentiment Analysis - Visualization

Hortonworks hive odbc driver for mac