create --create
listing jobs --list
detailed information about the job --show
execute job --exec
delete job --delete
Create a new job to import data from MySQL table to HDFS.
sqoop job --create myjob -- import --connect jdbc://192.168.13.136/retail_db --username cloudera --password --cloudera --table customers -- m1;
Listing available jobs
[cloudera@quickstart ~]$ sqoop job --list
Display detailed information about the job
[cloudera@quickstart ~]$ sqoop job --show myjob
Delete existing job
[cloudera@quickstart ~]$ sqoop job --delete myjob
[cloudera@quickstart ~]$ hdfs dfsadmin -safemode leave ---> changing HDFS save mode off
Execute sqoop job
[cloudera@quickstart ~]$ sqoop job --exec myjob
codgen command : generates code files for sqoop commands
[cloudera@quickstart ~]$ sqoop codegen --connect jdbc:mysql://192.168.13.136/retail_db --username cloudera --password cloudera --table customers
Verify files
[cloudera@quickstart ~]$ ls /tmp/sqoop-cloudera/compile/752b65100f5001f20bd57eb85a460b51/
