ERROR tool.ImportTool: Error during import: Import job failed! Trying to import Oracle tables using Sqoop. Getting error during the import job failed. I have attached the logs. Any thoughts!! mapreduce-import-failed.txt Can you please let me know your suggestions.. Thanks, ... View more

Hi, I am getting sqoop import error using oracle tables: sqoop error tool.importtool error during import import job failed Can you please advise. I have attached the log for your reference. Thank you.mapreduce-import-failed.txt ... View more

mapreduce-import-failed.txtHi, I am getting sqoop import error using oracle tables: sqoop error tool.importtool error during import import job failed Can you please advise. I have attached the log for your reference. Thank you. ... View more

Yes I did and ran the sqoop command again. Verified with Echo %sqoop_home% its showing the details in attached document. But same issue. sqoop-config.jpg ... View more

Hi Jitendra, I am expecting the same error, after following these commands. Can you please review once. The actuall error I am getting is Could not find or load main org.apache.sqoop.sqoop I ran this as adminstrator runas /user:administrator mklink C:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\yarn\hadoop-yarn-api-2.7.1.2.4.0.0-169.jar C:\hadoop\hdp\sqoop-1.4.6.2.4.0.0-169\lib\hadoop-yarn-api-2.7.1.2.4.0.0-169.jar C:\hadoop\hdp\sqoop-1.4.6.2.4.0.0-169\lib Set Yarn path (Attched the jpg) set sqoop path (attached the jpg) Executed the sqoop command after checking the classpath but getting the same error Could not find or load main org.apache.sqoop.sqooploadmainsqoopfail.pdf ... View more

Jithedra is it able to contact me? I am able to share the details. Please let me know. fnu.rasool@gmail.com Thanks, Rasool. ... View more

Yes. Its was SQOOP_HOME=C:\hdp\sqoop-1.4.6.2.4.0.0-169 I changed to SQOOP_HOME=C:\hdp but no luck. ... View more

Both jars are not same? Do I need to copy the second jar? hadoop-yarn-api-2.7.1.2.4.0.0-169 / hadoop-yarn-api.jar ... View more

Hi, I checked all the paths and all set. But its giving this exception. not sure what jar is missing? Exception in thread "main" java.lang.NoClassDefFoundError: org/apache/hadoop/yarn/exceptions/YarnException at org.apache.hadoop.mapred.YarnClientProtocolProvider.create(YarnClientProtocolProvider.java:34) at org.apache.hadoop.mapreduce.Cluster.initialize(Cluster.java:95) at org.apache.hadoop.mapreduce.Cluster.<init>(Cluster.java:82) at org.apache.hadoop.mapreduce.Cluster.<init>(Cluster.java:75) at org.apache.hadoop.mapreduce.Job$9.run(Job.java:1260) at org.apache.hadoop.mapreduce.Job$9.run(Job.java:1256) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAs(Subject.java:415) at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1657) at org.apache.hadoop.mapreduce.Job.connect(Job.java:1255) at org.apache.hadoop.mapreduce.Job.submit(Job.java:1284) at org.apache.hadoop.mapreduce.Job.waitForCompletion(Job.java:1308) at org.apache.sqoop.mapreduce.ImportJobBase.doSubmitJob(ImportJobBase.java:196) at org.apache.sqoop.mapreduce.ImportJobBase.runJob(ImportJobBase.java:169) at org.apache.sqoop.mapreduce.ImportJobBase.runImport(ImportJobBase.java:266) at org.apache.sqoop.manager.SqlManager.importTable(SqlManager.java:673) at org.apache.sqoop.manager.OracleManager.importTable(OracleManager.java:444) at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:497) at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:605) at org.apache.sqoop.Sqoop.run(Sqoop.java:148) at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:76) at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:184) at org.apache.sqoop.Sqoop.runTool(Sqoop.java:226) at org.apache.sqoop.Sqoop.runTool(Sqoop.java:235) at org.apache.sqoop.Sqoop.main(Sqoop.java:244) Caused by: java.lang.ClassNotFoundException: org.apache.hadoop.yarn.exceptions.YarnException at java.net.URLClassLoader$1.run(URLClassLoader.java:366) at java.net.URLClassLoader$1.run(URLClassLoader.java:355) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:354) ... View more