Sqoop error while trying to connect to MySql

0 votes

Hi, 

I am running below sqoop command but getting error. I'm using edureka VM

[edureka@localhost ~]$ sqoop import \
> --connect "jdbc:mysql://local/mydb" \
> --user root \
> --password Edurekasql_123 \
> --table elections \
> --target-dir /Test \
> -m 1;
Warning: /usr/lib/sqoop-1.4.6.bin__hadoop-2.0.4-alpha/../hbase does not exist! HBase imports will fail.
Please set $HBASE_HOME to the root of your HBase installation.
Warning: /usr/lib/sqoop-1.4.6.bin__hadoop-2.0.4-alpha/../hcatalog does not exist! HCatalog jobs will fail.
Please set $HCAT_HOME to the root of your HCatalog installation.
Warning: /usr/lib/sqoop-1.4.6.bin__hadoop-2.0.4-alpha/../accumulo does not exist! Accumulo imports will fail.
Please set $ACCUMULO_HOME to the root of your Accumulo installation.
18/12/22 21:58:02 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6
18/12/22 21:58:02 ERROR tool.BaseSqoopTool: Error parsing arguments for import:
18/12/22 21:58:02 ERROR tool.BaseSqoopTool: Unrecognized argument: --user
18/12/22 21:58:02 ERROR tool.BaseSqoopTool: Unrecognized argument: root
18/12/22 21:58:02 ERROR tool.BaseSqoopTool: Unrecognized argument: --password
18/12/22 21:58:02 ERROR tool.BaseSqoopTool: Unrecognized argument: Edurekasql_123
18/12/22 21:58:02 ERROR tool.BaseSqoopTool: Unrecognized argument: --table
18/12/22 21:58:02 ERROR tool.BaseSqoopTool: Unrecognized argument: elections
18/12/22 21:58:02 ERROR tool.BaseSqoopTool: Unrecognized argument: --target-dir
18/12/22 21:58:02 ERROR tool.BaseSqoopTool: Unrecognized argument: /Test
18/12/22 21:58:02 ERROR tool.BaseSqoopTool: Unrecognized argument: -m
18/12/22 21:58:02 ERROR tool.BaseSqoopTool: Unrecognized argument: 1
May 22, 2019 in Big Data Hadoop by Esha
2,205 views

1 answer to this question.

0 votes

Please use the below command to solve the problem :

sqoop import --connect jdbc:mysql://localhost/mydb --username root --password Edurekasql_123 --table elections --target-dir /Test1 -m 1;
answered May 22, 2019 by Bhagavath

Related Questions In Big Data Hadoop

0 votes
1 answer

Sqoop import failed while importing mysql table to Hbase

There is a spelling mistake in your ...READ MORE

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

Sqoop error while importing data from MySql

As the error states, the target directory ...READ MORE

answered Feb 11, 2019 in Big Data Hadoop by Omkar
• 69,210 points
1,858 views
0 votes
1 answer

How to connect Sqoop to mysql Database?

Hi. You can connect Sqoop to MySql ...READ MORE

answered May 15, 2019 in Big Data Hadoop by Tina
2,462 views
0 votes
1 answer

Error while copying the file from local to HDFS

Well, the reason you are getting such ...READ MORE

answered May 3, 2018 in Big Data Hadoop by Ashish
• 2,650 points
3,672 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
10,555 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
2,184 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
104,181 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
4,260 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,210 points
1,109 views
0 votes
1 answer

Error while hitting the hadoop jar command to execute my map reduce

Since your jar file was inside the ...READ MORE

answered Feb 12, 2019 in Big Data Hadoop by Omkar
• 69,210 points
1,296 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP