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 in Big Data Hadoop by Sunny
27 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 by Suri

Related Questions In Big Data Hadoop

0 votes
2 answers
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
• 68,160 points
274 views
0 votes
1 answer
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
• 68,160 points
186 views
0 votes
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
• 10,760 points
3,516 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
• 10,760 points
431 views
+1 vote
11 answers

hadoop fs -put command?

put syntax: put <localSrc> <dest> copy syntax: copyFr ...READ MORE

answered Dec 7, 2018 in Big Data Hadoop by Aditya
17,853 views
0 votes
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,280 points
1,293 views
0 votes
1 answer

How Sqoop import command works internally?

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

answered Apr 11 in Big Data Hadoop by Gitika
• 25,420 points
79 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
• 68,160 points
102 views