Hive - Project

10 / 14
   

In this step, we create a new table _tweetsbi_. We join _tweets_clean_ and _tweets_sentiment_ tables and store sentiment of each tweet. Each row of the _tweetsbi_ table contains tweet id, timestamp, tweet text, country and its sentiment

Steps-

  1. Create _tweetsbi_ table. 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;
    

    Sample rows of _tweetsbi_ table are


Now we have a sentiment of each tweet along with country from where this tweet was tweeted. In the next steps, we will visualize the sentiment of "Iron Man 3" movie in different countries.

Question-

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