sqoop export --connect jdbc:mysql://localhost/dbjpkn --table
usermaster_exp --username root --export-dir /user/user/usermaster


sqoop import-all-tables --connect jdbc:mysql://localhost/dbjpkn --username hive--password 12345678



sqoop job --create myjob3 -- import --connect jdbc:mysql://localhost/dbupm -
-username hive --password 12345678 --table usermaster


sqoop job --list

sqoop job --show myjob

sqoop job --exec myjob

sqoop job --exec myjob  --username hive -P


sqoop codegen --connect jdbc:mysql://localhost/dbupm --username root --table usermaster



sqoop eval --connect jdbc:mysql://localhost/dbupm --username root
--query “SELECT * FROM usermaster limit 2"



sqoop eval --connect jdbc:mysql://localhost/dbupm --username root
--query “SELECT * FROM usermaster order by userid "




sqoop eval --connect jdbc:mysql://localhost/dbupm --username root
--query “SELECT count(*) as NoofRec FROM usermaster "


sqoop eval --connect jdbc:mysql://localhost/dbupm --username root
 -e “INSERT INTO usermaster VALUES( 'aaa', 'bbb', 'ccc' )”



sqoop list-tables --connect jdbc:mysql://localhost/dbupm --username root