Sqoop import error with sqoop job

Question

Hi team, I had tried to create a sqoop job, but I am getting errors when I use the following sqoop command. Please run this from your end let me know where the problem was. Thanks

sqoop job --create retaildb_comerica --import --connect jdbc:mysql://mysqldb.edu.cloudlab.com/retail_db --table comerica --username labuser --password edureka --incremental append --check-column customer_id --last-value 12436 --target-dir /user/edureka_227114/Sqoop/inc-comerica -m 1

Answer 1

Please try the below command:

sqoop job -create retaildb_comercia -- import --connect jdbc:mysql://mysqldb.edu.cloudlab.com/retail_db --username labuser --P --table comercia --target-dir sayni_sqoop --check-column customer_id --incremental append --last-value 12436 -m 1

There needs to be a space between -- and import. Also, I am attaching a documentation for sqoop job.