Data Lake for Enterprises

Create job

A typical syntax for creating a Sqoop job execution can be defined as:

sqoop job (generic-args) (job-args)   [-- [subtool-name] (subtool-args)]

bin/sqoop job --create <JOB_NAME> -- <OPERATION_NAME> --connect jdbc:postgresql://<DB_SERVER>/sourcedb?schema=public --table <TABLE_NAME> --m 1 --username <DB_USER> --password <DB_PASSWORD> --as-avrodatafileWhere,<JOB_NAME>                   → Name of the job to be created<OPERATION_NAME>             → Name of the sqoop operation to be defined, e.g. import<DB_SERVER>                  → DB Server address or IP<TABLE_NAME>                 → Name of the table to be imported<DB_USER>                    → Username of the DB containing data to be imported<DB_PASSWORD>                → Password of the DB containing data to be imported

Please observe the spaces around --. These spaces are ...