hadoop-common-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Amandeep Khurana <ama...@gmail.com>
Subject Unable to pull data from DB in Hadoop job
Date Tue, 03 Feb 2009 23:34:47 GMT
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

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message