One Star

Error while submitting sqoop job.

Hi,
i am getting below error while trying to use sqoop import from oracle.
Exception in thread "main" java.lang.NoClassDefFoundError: org/apache/commons/lang3/StringUtils
at org.apache.sqoop.manager.oracle.OracleUtils.escapeIdentifier(OracleUtils.java:36)
at org.apache.sqoop.manager.OracleManager.escapeTableName(OracleManager.java:927)
at org.apache.sqoop.manager.OracleManager.getColNamesQuery(OracleManager.java:264)
at org.apache.sqoop.manager.SqlManager.getColTypesQuery(SqlManager.java:240)
at org.apache.sqoop.manager.SqlManager.getColumnTypes(SqlManager.java:245)
at org.apache.sqoop.manager.ConnManager.getColumnTypes(ConnManager.java:328)
at org.apache.sqoop.orm.ClassWriter.getColumnTypes(ClassWriter.java:1853)
at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1653)
at org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:107)
at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:488)
at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:615)
at org.apache.sqoop.Sqoop.run(Sqoop.java:147)
at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:76)
disconnected
disconnected
at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:183)
at test.oth_test_0_1.oth_test.tSqoopImport_1Process(oth_test.java:586)
at test.oth_test_0_1.oth_test.tOracleConnection_1Process(oth_test.java:428)
at test.oth_test_0_1.oth_test.runJobInTOS(oth_test.java:994)
at test.oth_test_0_1.oth_test.main(oth_test.java:851)
Caused by: java.lang.ClassNotFoundException: org.apache.commons.lang3.StringUtils
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
... 18 more
Job oth_test ended at 16:49 05/01/2017.

I have added ojdbc6.jar and class name as "oracle.jdbc.driver.OracleDriver" in the component.
i am using below
please help me further.
thanks,
Rishit Shah
2 REPLIES
One Star

Re: Error while submitting sqoop job.

pfa.
One Star

Re: Error while submitting sqoop job.

pfa