Project - Sentiment Analysis in Hive

6 / 10

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

Question-

What is the time zone of the country FINLAND?

INSTRUCTIONS
  1. Launch hive console by typing the hive command in the web console.

    hive
    
  2. Create an external table time_zone_map. Run below command in Hive on your web console. ${env:USER} gets replaced by your username automatically.

    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/${env:USER}/SentimentFiles/SentimentFiles/upload/data/time_zone_map';
    

Sample rows of time_zone_map table are



Note - Having trouble with the assessment engine? Follow the steps listed here


Loading comments...