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

Yadav, The first jar is hadoop-yarn-api-2.7.1.2.4.0.0-169 Can you please review the jpg. Thank you. ... View more

I checked the jars and its available. Please review the attached copy. -thanks,hadoopyarncommonjars.jpg ... View more

Thank you Ravi. Do you think, I need to change core-site.xml file also? please suggest. thanks ... View more

We installed HDP 2.4 on windows server for Pilot project to analyze the execution. We have oracle tables/data to export on Hive and check the operation. For that, I need to install the Hcatalog or any other interface to use Hive on HDP 2.4 with windows server installation. I didnt able to find Hcatalog due to its not Linux on command prompt. Please advise. ... View more