SQOOP Import command failure

0 votes

Hi,

I connected to MySQL with below command in cloud lab, and created database and "sample" and table "Students"

Command: mysql -u labuser -h mysqldb.edu.cloudlab.com -p

Password: edureka

And When I am trying the below sqoop import command, I am getting connection failure error

sqoop import --connect jdbc:mysql://localhost/sample --username edureka --table Students

Jun 20, 2019 in Big Data Hadoop by Sunny
133 views

1 answer to this question.

0 votes

Try this command where the student table in imported to hdfs:

sqoop import --connect jdbc:mysql://mysqldb.edu.cloudlab.com/mani --username=labuser --password=edureka --table Students -m 1 -target-dir student.csv
answered Jun 20, 2019 by Suri

Related Questions In Big Data Hadoop

0 votes
2 answers

How to pass a password to Sqoop import command?

You can directly pass the password in ...READ MORE

answered May 15, 2019 in Big Data Hadoop by Raj
3,719 views
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,150 points
991 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,150 points
1,137 views
0 votes
1 answer

Sqoop import not working

The error you are getting is because ...READ MORE

answered Dec 18, 2018 in Big Data Hadoop by Omkar
• 69,150 points
532 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
8,027 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,366 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
66,727 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,058 views
0 votes
1 answer

How Sqoop import command works internally?

First when client execute Sqoop import commands through ...READ MORE

answered Apr 11, 2019 in Big Data Hadoop by Gitika
• 65,970 points
412 views
0 votes
1 answer

How to use sqoop import?

Here is an example of import command. ...READ MORE

answered Dec 14, 2018 in Big Data Hadoop by Omkar
• 69,150 points
301 views