Hive - Project

10 / 14
Hive - Project - Sentiment Analysis - Step - 8

In this step, we will put everything back together and re-number the sentiment.

Steps-

  1. Create tweetsbi table. Each row of the tweetsbi contains tweet id, timestamp, tweet text, country and its sentiment. Run the below command in Hive query editor in Hue.
    CREATE TABLE tweetsbi 
    STORED AS ORC
    AS
    SELECT 
    t.*,
    s.sentiment 
    FROM tweets_clean t LEFT OUTER JOIN tweets_sentiment s on t.id = s.id;
    

Question-

What is the country and sentiment of the tweet with id as 330043924896968707?

  • SPAIN, neutral
  • INDIA, negative
  • MOROCCO, positive
  • None of the above