Good evening!
Today I got access to Cloudera Live/GoGrid and started to work through the tutorial starting at the very beginning - using Sqoop to import a MySQL DB.
I copied this command from the tutorial guide:
sqoop import-all-tables \
-m 12 \
--connect jdbc:mysql://i7d61-cldramaster-01:3306/retail_db \
--username=retail_dba \
--password=cloudera \
--compression-codec=snappy \
--as-avrodatafile \
--warehouse-dir=/user/hive/warehouse
However, I receive multiple errors relating to a 'Communications link failure, here is a snippet:
14/10/28 18:35:14 INFO sqoop.Sqoop: Running Sqoop version: 1.4.4-cdh5.1.0
14/10/28 18:35:14 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead.
14/10/28 18:35:14 INFO manager.MySQLManager: Preparing to use a MySQL streaming resultset.
14/10/28 18:35:14 ERROR manager.CatalogQueryManager: Failed to list tables
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
I understand from research this typically relates to connectivity issues, but as I am using a self contained environment designed for this tutorial I would not have expected to have these types of issues. 🙂
Any guidence would be appreciated!
Thanks.