Project - Sentiment Analysis in Hive

6 / 10
Previous Index Next  

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


Get Hint See Answer

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


Previous Index Next  

Loading comments...