Created 10-12-2020 12:44 AM
I am using sqoop to import the oracle table employee into HDFS using this command:
./sqoop import --connect jdbc:oracle:thin:oracle/oracle@localhost:1521:XE --username oracle -P --table employee --target-dir /out10 -m 1
But, it shows this error:
ERROR orm.CompilationManager: Could not rename /tmp/sqoop-cloudera/compile/f616bbc3dd133f642f04f5e95514fce0/employee.java to /usr/lib/sqoop/bin/./employee.java
Is there any way to figure out this problem?
Created 10-12-2020 01:22 AM
@Muraliselvaraj When a Sqoop program is executed, it will create a java file like QueryResult.java in the current directory. If QueryResult.java is already there as we already executed the Sqoop command before, the message will be shown. The path needs to be new every time, as this is how the sqoop is designed.
As far as I know it is by design we are seeing this ERROR message, this is a harmless message. 'xxx.java' is the Java source code file which is generated by Sqoop itself on the fly. This would not cause any job failure. 'xxx.java' is only used to be compiled to the actual .class file which is used to submit as MR job. After the job is submitted, we can safely delete it.
Are you seeing any job failure because of this error message?
Created 10-12-2020 08:19 AM
yes , job is failed...
ERROR tool.ImportTool: Error during import: Import job failed!