Support Questions

Find answers, ask questions, and share your expertise
Celebrating as our community reaches 100,000 members! Thank you!

Who agreed with this topic

Exercise 1 sqoop errors: Communications link failure


I am following the steps in Execrice 1 . sqoop is failing. Below is more details.


$ sqoop import-all-tables  -m 1 --connect jdbc:mysql://{{cluster_data.manager_node_hostname}}:3306/retail_db --username=retail_dba --password=cloudera --compression-codec=snappy --as-parquetfile --warehouse-dir=/user/hive/warehouse --hive-import

Warning: /opt/cloudera/parcels/CDH-5.4.2-1.cdh5.4.2.p0.2/bin/../lib/sqoop/../accumulo does not exist! Accumulo imports will fail.

Please set $ACCUMULO_HOME to the root of your Accumulo installation.

16/01/05 01:45:42 INFO sqoop.Sqoop: Running Sqoop version: 1.4.5-cdh5.4.2

16/01/05 01:45:42 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead.

16/01/05 01:45:42 INFO tool.BaseSqoopTool: Using Hive-specific delimiters for output. You can override

16/01/05 01:45:42 INFO tool.BaseSqoopTool: delimiters with --fields-terminated-by, etc.

16/01/05 01:45:42 WARN tool.BaseSqoopTool: It seems that you're doing hive import directly into default

16/01/05 01:45:42 WARN tool.BaseSqoopTool: hive warehouse directory which is not supported. Sqoop is

16/01/05 01:45:42 WARN tool.BaseSqoopTool: firstly importing data into separate directory and then

16/01/05 01:45:42 WARN tool.BaseSqoopTool: inserting data into hive. Please consider removing

16/01/05 01:45:42 WARN tool.BaseSqoopTool: --target-dir or --warehouse-dir into /user/hive/warehouse in

16/01/05 01:45:42 WARN tool.BaseSqoopTool: case that you will detect any issues.

16/01/05 01:45:42 INFO manager.MySQLManager: Preparing to use a MySQL streaming resultset.

16/01/05 01:45:43 ERROR manager.CatalogQueryManager: Failed to list tables

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure


The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(




Caused by: {{cluster_data.manager_node_hostname}}

at Method)






at com.mysql.jdbc.StandardSocketFactory.connect(

at com.mysql.jdbc.MysqlIO.<init>(

... 24 more


I am using -m 1 based on earlier thread. MySQL instance is running.


Any assistance will be much appreciated.


Who agreed with this topic