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.

The post big data hive and impala appeared first on Custom Nursing Help.

 

"Is this question part of your assignment? We Can Help!"

Essay Writing Service