Enrollments Open for Advanced Certification Courses on Data Science, ML & AI by E&ICT Academy IIT RoorkeeApply Now
Tableau is a visualization tool. We can connect to Hive using Tableau and transform data stored in Hive into visually appealing and interactive visualizations.
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
Let's use tableau.
Username and Passwordas Authentication.
Sign inand wait for the connection to establish.
_tweetsbi_table in Hive.
tweetsbitable under your database and select it.
Sentimentfrom dimensions and
Number of recordsfrom measures and click on
show meto see the recommended chart by Tableau.
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.
No hints are availble for this assesment
Answer is not availble for this assesment