Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Sqoop import error in Azure Sandbox

Highlighted

Sqoop import error in Azure Sandbox

New Contributor

I need help regarding how to import the data in HDFS using sqoop :


I am getting below error ;


The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.                     com.mysql.jdbc.exceptions.jdbc4.Commun
icationsException: Communications link failure   

Using below commands :

sqoop import --connect jdbc:mysql://localhost/test --driver com.mysql.jdbc.Driver --username maria_dev --password maria_dev

--table EMP --target-dir /user/maria_dev/Sqoop_demo -m 1


sqoop import --connect jdbc:mysql://mukulhadoopsandbox.westus.cloudapp.azure.com/test --table EMP --username root -P -m 1 --fetch-size 1



sqoop import --connect jdbc:mysql://mukulhadoopsandbox.westus.cloudapp.azure.com/test --table EMP --hive-import

--hive-table EMP --username root -P -m 1 --fetch-size 1





sqoop list-tables --connect jdbc:mysql://mukulhadoopsandbox.westus.cloudapp.azure.com/test --driver com.mysql.jdbc.Driver --username root -P