Member since
10-28-2014
2
Posts
0
Kudos Received
1
Solution
My Accepted Solutions
Title | Views | Posted |
---|---|---|
1967 | 10-29-2014 04:55 PM |
10-29-2014
04:55 PM
Coming back to this today, I never thought to initialy check if MySQL Server was actually running. Which it wasnt 🙂 After enabling the service on the master node (which is where the DB is stored for the Cloudera Live demo), everything worked well.
... View more
10-28-2014
06:58 PM
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.
... View more
Labels:
- Labels:
-
Apache Hive
-
Apache Sqoop