CCA159 : Task Scenario-40

Problem Scenario 40 :  You have been given MySQL DB with following details. 

user=retail_dba 

password=cloudera 

database=retail_db

table=retail_db.categories

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

Please accomplish following activities.

1. Connect MySQL DB and check the content of the tables.

2. Copy "retail_db.categories" table to hdfs, without specifying directory name.

3. Copy "retail_db.categories" table to hdfs, in a directory name "categories_target".

4. Copy "retail_db.categories" table to hdfs, in a warehouse directory name "categories_warehouse".