Hive - Project

9 / 14
Hive - Project - Sentiment Analysis - Step - 7

In this step, we will calculate sentiment of each tweet.

Steps-

  1. Create tweets_sentiment table. Each row of tweets_sentiment table stores the sentiment of the tweet. Sample rows of tweets_sentiment table are
    Run below command in the Hive query editor in Hue
    create table tweets_sentiment stored as orc as select 
    id, 
    case 
    when sum( polarity ) > 0 then 'positive' 
    when sum( polarity ) < 0 then 'negative'  
    else 'neutral' end as sentiment 
    from l3 group by id;
    

Question-

What is the sentiment of tweet with id as 330043911940751360?

  • positive
  • neutral
  • negative
  • None of the above