MySQL Connectivity Issues via Cloudera Live Sqoop Example/Tutorial?

Omoshirou — Fri, 16 Sep 2022 09:10:58 GMT

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.

Re: MySQL Connectivity Issues via Cloudera Live Sqoop Example/Tutorial?

Omoshirou — Wed, 29 Oct 2014 23:55:38 GMT

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.

question MySQL Connectivity Issues via Cloudera Live Sqoop Example/Tutorial? in Archives of Support Questions (Read Only)

MySQL Connectivity Issues via Cloudera Live Sqoop Example/Tutorial?

Re: MySQL Connectivity Issues via Cloudera Live Sqoop Example/Tutorial?