Lab#6
Hive and Impala

1)Import table “webpage” via Sqoop
$ sqoop import
–connect jdbc:mysql://localhost/loudacre
–username training –password training
–table webpage
–target-dir /loudacre/webpage
–fields-terminated-by “t”

2)Validate the imported data in HDFS ( Please provide screenshot from Terminal and NOT HUE )

3)Create External Table via Hive session
CREATE EXTERNAL TABLE webpage
(page_id SMALLINT,
name STRING,
assoc_files STRING)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ‘t’
LOCATION ‘/loudacre/webpage’

4)Open FireFox browser and run the below query from Hive
SELECT * FROM webpage WHERE name LIKE “ifruit%”

5)Open FireFox browser and run the below query from Impala
SELECT * FROM webpage WHERE name LIKE “ifruit%”
 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!Use Discount Code “Newclient” for a 15% Discount!NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.

 

"Get 20% OFF on a Similar Assignment!! Place Your Order and Use this Coupon Code: SUPER20"

buy custom essays