ACCESSING THE MYSQL/RDBMS DB FROM HADOOP USEING SQOOP

1. CREATE A FOLDER ON LOCAL MACHINE WHERE DATA WILL BE KEPT TO SHARE WITH CLOUDERA MACHINE
2.OPEN CLOUDERA VM AND CLICK ON DEVICES -> CLICK ON SHARED FOLDERS -> SHARED FOLDER SETTINGS
3. CLICK ON ADD/+BUTTON
4. BROSE THE FOLDER PATH THEN SELECT THE FOLDER WHICH WE CREATED IN STEP 1
5. CHECK/MARK ON MAKE PERMANENT
6.THEN OK -> OK

NOW OPEN TERMINAL IN CLOUDERA VM
$cd Desktop
$ mkdir <dir-name>
$ su
$ pwd: cloudera
# now to mount the local folder on clouder vm
$ # mount -t vboxsf shared shared

# this below ex is to demonstrate how to list the databases of mysql/redbms from hadoop cloudser i.e we are not log in to mysql/rdbms termial but directly from hadoop terminal only we are list the data bases;

# this scenario when we have to check the databases from hadoop terminal only 

[cloudera@quickstart ~]$ sqoop-list-databases \
--connect jdbd:mysql://quikcstart.cloudera:3306 \
--username retail_dba \
--passord cloudera

sqoop-list-tables --connect \
jdbc:mysql://quickstart.cloudera:3306/retail_db \
--username retail_dba \
--password cloudera

sqoop-eval \
--connect jdbc:mysql://quickstart.cloudera:3306/retail_db \
--username retail_dba \
--password cloudera \
-query "select product_id,product_image from products limit 2";