Return-Path: Delivered-To: apmail-hadoop-core-user-archive@www.apache.org Received: (qmail 19776 invoked from network); 3 Feb 2009 23:35:22 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 3 Feb 2009 23:35:22 -0000 Received: (qmail 8200 invoked by uid 500); 3 Feb 2009 23:35:15 -0000 Delivered-To: apmail-hadoop-core-user-archive@hadoop.apache.org Received: (qmail 8160 invoked by uid 500); 3 Feb 2009 23:35:15 -0000 Mailing-List: contact core-user-help@hadoop.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: core-user@hadoop.apache.org Delivered-To: mailing list core-user@hadoop.apache.org Received: (qmail 8149 invoked by uid 99); 3 Feb 2009 23:35:15 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 03 Feb 2009 15:35:15 -0800 X-ASF-Spam-Status: No, hits=2.2 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of amansk@gmail.com designates 209.85.221.20 as permitted sender) Received: from [209.85.221.20] (HELO mail-qy0-f20.google.com) (209.85.221.20) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 03 Feb 2009 23:35:08 +0000 Received: by qyk13 with SMTP id 13so3362304qyk.5 for ; Tue, 03 Feb 2009 15:34:47 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:date:message-id:subject :from:to:content-type; bh=klO/TEZSRchP+FlujI7P0jH0MV4EfRzwHZtIqE3GQNY=; b=AwRGK0IC63qryjOXCaWdoEImAylQWBkeuY2TWDlut+zb1yGFcwfCOfp5efKmpAdP3R OT+mIsvwqkACRuL84/exOCZyb3xKmcnPatT6fEUbyw0sfKpTui5t0qQyH5mjZlfhpdYS WqcqWPKrY2rcPpcO/T06uOKgMPjEBAZntr7Do= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:date:message-id:subject:from:to:content-type; b=E+5BvSAVVohTbZEmCqUjU2DBbzsv/V78k1laaOqFCTIs0FROrvcE0sAxO6GGM2x749 TZuJDza6/Mspgo8Syty1f5L2RaEgO7LNLuaA/cKesQLVKj61qJ4VHsJP6yMWBWsIpWA0 6k3rqKN4WbXfhOFOiHZxGBLNNJSveEu0HaZOs= MIME-Version: 1.0 Received: by 10.215.15.6 with SMTP id s6mr7081115qai.117.1233704087637; Tue, 03 Feb 2009 15:34:47 -0800 (PST) Date: Tue, 3 Feb 2009 15:34:47 -0800 Message-ID: <35a22e220902031534q69aba35dl55f26d5305a106b8@mail.gmail.com> Subject: Unable to pull data from DB in Hadoop job From: Amandeep Khurana To: core-user@hadoop.apache.org Content-Type: multipart/alternative; boundary=0015175cd2eee6cda404620c1da4 X-Virus-Checked: Checked by ClamAV on apache.org --0015175cd2eee6cda404620c1da4 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit 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 --0015175cd2eee6cda404620c1da4--