Dear Team,
we are unable to execute the sqoop import command for importing the data from postgres database to HDFS file system. We are using Pentaho Data Integration tool for sqoop command. version is pdi-ce-5.0.1-stable version. while executing the sqoop command from pdi tool we get following exception.




Sqoop Import - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : 2013/12/10 16:16:38 - java.lang.RuntimeException: java.lang.ClassNotFoundException: org.apache.sqoop.mapreduce.RawKeyTextOutputFormat




We have set the required jar files in the class path on remote hadoop server from where sqoop command is getting executed. Still getting this exception. Please suggest solution for this problem.




2013/12/10 16:16:38 - Sqoop Import - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : 2013/12/10 16:16:38 - java.lang.RuntimeException: java.lang.ClassNotFoundException: org.apache.sqoop.mapreduce.RawKeyTextOutputFormat
at org.apache.hadoop.conf.Configuration.getClass(Configuration.java:809)
at org.apache.hadoop.mapreduce.JobContext.getOutputFormatClass(JobContext.java:193)
at org.apache.hadoop.mapred.Task.initialize(Task.java:413)
at org.apache.hadoop.mapred.MapTask.run(MapTask.java:288)
at org.apache.hadoop.mapred.Child.main(Child.java:170)
Caused by: java.lang.ClassNotFoundException: org.apache.sqoop.mapreduce.RawKeyTextOutputFormat
at java.net.URLClassLoader$1.run(URLClassLoader.java:217)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:205)
at java.lang.ClassLoader.loadClass(ClassLoader.java:323)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:294)
at java.lang.ClassLoader.loadClass(ClassLoader.java:268)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:336)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:264)
at org.apache.hadoop.conf.Configuration.getClassByName(Configuration.java:762)
at org.apache.hadoop.conf.Configuration.getClass(Configuration.java:807)
... 4 more
2013/12/10 16:16:47 - Sqoop Import - 2013/12/10 16:16:47 - Task Id : attempt_201311211521_1167_m_000002_1, Status : FAILED
2013/12/10 16:16:47 - Sqoop Import - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : 2013/12/10 16:16:47 - java.lang.RuntimeException: java.lang.ClassNotFoundException: org.apache.sqoop.mapreduce.RawKeyTextOutputFormat
at org.apache.hadoop.conf.Configuration.getClass(Configuration.java:809)
at org.apache.hadoop.mapreduce.JobContext.getOutputFormatClass(JobContext.java:193)
at org.apache.hadoop.mapred.Task.initialize(Task.java:413)
at org.apache.hadoop.mapred.MapTask.run(MapTask.java:288)
at org.apache.hadoop.mapred.Child.main(Child.java:170)
Caused by: java.lang.ClassNotFoundException: org.apache.sqoop.mapreduce.RawKeyTextOutputFormat
at java.net.URLClassLoader$1.run(URLClassLoader.java:217)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:205)
at java.lang.ClassLoader.loadClass(ClassLoader.java:323)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:294)
at java.lang.ClassLoader.loadClass(ClassLoader.java:268)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:336)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:264)
at org.apache.hadoop.conf.Configuration.getClassByName(Configuration.java:762)
at org.apache.hadoop.conf.Configuration.getClass(Configuration.java:807)
... 4 more




Hiro.