• 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.
  • No labels