- 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.
{"serverDuration": 82, "requestCorrelationId": "46aea068ca7533fa"}