solvedL a b # 6 H i v e a n d I m p a l a 1 ) I m p o r t t a b l e w e b p a g e v i a S q o o p $ s q o o p i m p o r t c o n n e c t j d b c : m y s q l : / / l

Lab#6Hive and Impala1)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 t2)Validate the imported data in HDFS ( Please provide screenshot from Terminal and NOT HUE )3)Create External Table via Hive sessionCREATE EXTERNAL TABLE webpage (page_id SMALLINT name STRING assoc_files STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY t LOCATION /loudacre/webpage4)Open FireFox browser and run the below query from HiveSELECT * FROM webpage WHERE name LIKE ifruit%5)Open FireFox browser and run the below query from ImpalaSELECT * FROM webpage WHERE name LIKE ifruit%