Question

I am getting java.lang.IllegalArgumentException: during importing tables from oracle database.what might be the root cause and fix for this error scenario?

Answer 1

Sqoop commands are case- sensitive of table names and user names.

By specifying the above two values in UPPER case, it will resolve the issue.

In case, the source table is created under different user namespace,then table name should be like USERNAME.TABLENAME as shown below

sqoop import

–connect jdbc:oracle:thin:@intellipaat.testing.com/INTELLIPAAT

–username SQOOP

–password sqoop

–table COMPANY.EMPLOYEES