I am trying to pull data out from an oracle database using a hadoop job and am getting the following error which I am unable to debug.
09/02/03 15:32:51 INFO mapred.JobClient: Task Id : attempt_200902012320_0022_m_000001_2, Status : FAILED java.io.IOException: ORA-00933: SQL command not properly ended at org.apache.hadoop.mapred.lib.db.DBInputFormat.getRecordReader(DBInputFormat.java:289) at org.apache.hadoop.mapred.MapTask.run(MapTask.java:321) at org.apache.hadoop.mapred.Child.main(Child.java:155) java.io.IOException: Job failed! at org.apache.hadoop.mapred.JobClient.runJob(JobClient.java:1217) at LoadTable1.run(LoadTable1.java:130) at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65) at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:79) at LoadTable1.main(LoadTable1.java:107) Can anyone give me pointers on this? Thanks Amandeep Amandeep Khurana Computer Science Graduate Student University of California, Santa Cruz