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
12 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
• 67,120 points
159 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
• 67,120 points
116 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,110 points
2,056 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,110 points
198 views
0 votes
10 answers

hadoop fs -put command?

copy command can be used to copy files ...READ MORE

answered Dec 7, 2018 in Big Data Hadoop by Sujay
10,519 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,240 points
768 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
• 19,720 points
27 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
• 67,120 points
65 views