Step1: $mysql -uroot -pcloudera Step 2: show Databases; Step 3: Use retail_db; Step4: Show Tables; Step 5: Choose Table departments select * From departments; Step 6: Open New Terminal and Write import command. Step 7: import command from mysql to HDFS $ sqoop import --connect jdbc:mysql://localhost:3306/retail_db --username root -- password cloudera --table departments; This will take sometime to process Step 8: To check file imported in HDFS use below command $ hadoop fs -ls /user/cloudera; Step 9: To check the content of the file $ hadoop fs -cat /user/cloudera/departments/part* step10: Create New Table in Mysql (Terminal 1) Create Table departments_hdfs(deptid INT, deptName Varchar(20)); This will create new table in mysql Verify: show Tables; step 11: Open New Terminal and Write export command. Step 12. Export Command HDFS TO Mysql. $ sqoop export --connect jdbc:mysql://localhost:3306/retail_db --username root -- password cloudera --table departments_hdfs --export-dir /user/cloudera/departments/part* Step 13. In First cmd Select * From departments_hdfs;