Sqoop ERROR tool BaseSqoopTool Error parsing arguments

Question

I am trying to run Sqoop import command but getting the below error:

[edureka_601344@ip-20-0-41-62 ~]$ sqoop import --connect jdbc:mysql://mysqldb.edu.cloudlab.com/employee --username labuser --passowrd edureka --table departments --target-dir /TestData --m 1
Warning: /opt/cloudera/parcels/CDH-5.11.1-1.cdh5.11.1.p0.4/bin/../lib/sqoop/../accumulo does not exist! Accumulo imports will fail.
Please set $ACCUMULO_HOME to the root of your Accumulo installation.
19/06/01 23:01:29 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6-cdh5.11.1
19/06/01 23:01:29 ERROR tool.BaseSqoopTool: Error parsing arguments for import:
19/06/01 23:01:29 ERROR tool.BaseSqoopTool: Unrecognized argument: --passowrd
19/06/01 23:01:29 ERROR tool.BaseSqoopTool: Unrecognized argument: edureka
19/06/01 23:01:29 ERROR tool.BaseSqoopTool: Unrecognized argument: --table
19/06/01 23:01:29 ERROR tool.BaseSqoopTool: Unrecognized argument: departments
19/06/01 23:01:29 ERROR tool.BaseSqoopTool: Unrecognized argument: --target-dir
19/06/01 23:01:29 ERROR tool.BaseSqoopTool: Unrecognized argument: /TestData
19/06/01 23:01:29 ERROR tool.BaseSqoopTool: Unrecognized argument: --m
19/06/01 23:01:29 ERROR tool.BaseSqoopTool: Unrecognized argument: 1

Please explain what is wrong here and how to execute it.

Answer 1

There are two mistakes in the command you are executing,

1. The spelling of password is incorrect in the command.

2. There should not be a forward slash before writing the target directory name. The default path of target directory is hdfs://nameservice1/user/edureka_<your_id>/. So, you don't have to mention the complete path in the command and also the forward slash. You can directly write the directory name.

So, the correct command will be as below,

sqoop import --connect jdbc:mysql://mysqldb.edu.cloudlab.com/employee --username labuser --password edureka --table departments --target-dir TestData --m 1