Login using Social Account
     Continue with GoogleLogin using your credentials
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?
Launch hive console by typing the hive
command in the web console.
hive
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
Taking you to the next exercise in seconds...
Want to create exercises like this yourself? Click here.
Note - Having trouble with the assessment engine? Follow the steps listed here
Loading comments...