How do I resolve a Communications Link Failure when connecting to MySQL?
Verify that you can connect to the database from the node where you are running Sqoop: $ mysql --host=<IP Address> --database=test --user=<username> --password=<password> Add the network port for the server to your my.cnf file Set up a user account to connect via Sqoop. Grant permissions to the user to access the database over the network: Log into MySQL as root mysql -u root -p<ThisIsMyPassword> Issue the following command: mysql> grant all privileges on test.* to 'testuser'@'%' identified by 'testpassword'
How do I resolve an IllegalArgumentException when connecting to Oracle?
This could be caused a non-owner trying to connect to the table so prefix the table name with the schema, for example SchemaName.OracleTableName.
What's causing this "Exception in thread "main" java.lang.IncompatibleClassChangeError" when running non-CDH Hadoop with Sqoop?
Try building Sqoop 1.4.1-incubating with the command line property -Dhadoopversion=20.
How do I resolve an ORA-00933 error (SQL command not properly ended) when connecting to Oracle?
Omit the option --driver oracle.jdbc.driver.OracleDriver and then re-run the Sqoop command.