Hive - Project

6 / 14
Hive - Project - Sentiment ...
   

The objective of this step is to create an external table time_zone_map. time_zone_map table is a temporary table which is used to map user's timezone in the tweet to the country in the next steps

Steps-

Create an external table time_zone_map. Run below command in Hive query editor in Hue. Replace YOUR_USER_NAME with your CloudxLab username.

    CREATE EXTERNAL TABLE time_zone_map (
    time_zone string,
    country string,
    notes string
    )
    ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' 
    STORED AS TEXTFILE
    LOCATION '/user/YOUR_USER_NAME/SentimentFiles/SentimentFiles/upload/data/time_zone_map';

Sample rows of time_zone_map table are


Question-

What is the time zone of country FINLAND?