Cannot create Sqoop job on the Itversity Lab

#1

Hello,

I am encountering difficulty creating Sqoop jobs on the Lab.

I have written the following query and subsequently, generated the log error:

sqoop job --create xxx \

–import
–connect jdbc:mysql://ms.itversity.com/retail_db
–username retail_user
–password itversity
–table orders
–target-dir /user/por160893/sqoop_import/orders
–num-mappers 1
19/04/11 04:32:13 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6.2.6.5.0-292
19/04/11 04:32:13 ERROR tool.BaseSqoopTool: Error parsing arguments for job:
19/04/11 04:32:13 ERROR tool.BaseSqoopTool: Unrecognized argument: --import
19/04/11 04:32:13 ERROR tool.BaseSqoopTool: Unrecognized argument: --connect
19/04/11 04:32:13 ERROR tool.BaseSqoopTool: Unrecognized argument: jdbc:mysql://ms.itversity.com/retail_db
19/04/11 04:32:13 ERROR tool.BaseSqoopTool: Unrecognized argument: --username
19/04/11 04:32:13 ERROR tool.BaseSqoopTool: Unrecognized argument: retail_user
19/04/11 04:32:13 ERROR tool.BaseSqoopTool: Unrecognized argument: --password
19/04/11 04:32:13 ERROR tool.BaseSqoopTool: Unrecognized argument: itversity
19/04/11 04:32:13 ERROR tool.BaseSqoopTool: Unrecognized argument: --table
19/04/11 04:32:13 ERROR tool.BaseSqoopTool: Unrecognized argument: orders
19/04/11 04:32:13 ERROR tool.BaseSqoopTool: Unrecognized argument: --target-dir
19/04/11 04:32:13 ERROR tool.BaseSqoopTool: Unrecognized argument: /user/por160893/sqoop_import/orders
19/04/11 04:32:13 ERROR tool.BaseSqoopTool: Unrecognized argument: --num-mappers
19/04/11 04:32:13 ERROR tool.BaseSqoopTool: Unrecognized argument: 1

Can someone please help with this matter as I am very confused :frowning:

Many thanks,
Patrick

0 Likes

#2

@PatrickO_Rourke You need to give a space between and import as -- import in sqoop job.

0 Likes