Scenario-5

Have you subscribed for update ? Please subscribe here

Problem Scenario 5 : You have been given following mysql database details.

user=retail_dba 

password=cloudera 

database=retail_db

jdbc URL = jdbc:mysql://quickstart:3306/retail_db

Please accomplish following activities.

1. List all the tables using sqoop command from retail_db

2. Write simple sqoop eval command to check whether you have permission to read database tables or not.

3. Import all the tables as avro files in /user/hive/warehouse/retail_cca174.db

4. Import departments table as a text file in /user/cloudera/departments.