Sqoop ERROR tool BaseSqoopTool Error parsing arguments

0 votes

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.

Aug 2, 2019 in Big Data Hadoop by Will
4,004 views

1 answer to this question.

0 votes

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 
answered Aug 2, 2019 by Kunal

Related Questions In Big Data Hadoop

0 votes
1 answer

Sqoop: ERROR tool.BaseSqoopTool: Unrecognized argument

The command you are executing is slightly ...READ MORE

answered Aug 1, 2019 in Big Data Hadoop by Sam
2,631 views
0 votes
1 answer
0 votes
1 answer

Hadoop sqoop import not working. Error: ERROR manager.SqlManager: Error reading from database

In the command, try mentioning the driver ...READ MORE

answered Dec 5, 2018 in Big Data Hadoop by Omkar
• 69,170 points
963 views
0 votes
1 answer

Sqoop import gives error: org.apache.hadoop.security.AccessControlException: Permission denied

Seems like you are not passing the ...READ MORE

answered Dec 17, 2018 in Big Data Hadoop by Omkar
• 69,170 points
1,116 views
+1 vote
1 answer

Hadoop Mapreduce word count Program

Firstly you need to understand the concept ...READ MORE

answered Mar 16, 2018 in Data Analytics by nitinrawat895
• 11,380 points
7,929 views
0 votes
1 answer

hadoop.mapred vs hadoop.mapreduce?

org.apache.hadoop.mapred is the Old API  org.apache.hadoop.mapreduce is the ...READ MORE

answered Mar 16, 2018 in Data Analytics by nitinrawat895
• 11,380 points
1,341 views
+2 votes
11 answers

hadoop fs -put command?

Hi, You can create one directory in HDFS ...READ MORE

answered Mar 16, 2018 in Big Data Hadoop by nitinrawat895
• 11,380 points
63,187 views
–1 vote
1 answer

Hadoop dfs -ls command?

In your case there is no difference ...READ MORE

answered Mar 16, 2018 in Big Data Hadoop by kurt_cobain
• 9,390 points
3,012 views
0 votes
1 answer

Sqoop getting error while connecting to MySQL

Have you set a password for MySQL? ...READ MORE

answered Feb 7, 2019 in Big Data Hadoop by Omkar
• 69,170 points
346 views
0 votes
1 answer

Sqoop import: import failed error

The problem which you are facing is ...READ MORE

answered Feb 12, 2019 in Big Data Hadoop by Omkar
• 69,170 points
1,635 views