SQOOP Import command failure

Question

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

Answer 1

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