Return-Path: Delivered-To: apmail-hadoop-mapreduce-issues-archive@minotaur.apache.org Received: (qmail 8541 invoked from network); 6 Jan 2010 02:26:19 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 6 Jan 2010 02:26:19 -0000 Received: (qmail 45588 invoked by uid 500); 6 Jan 2010 02:26:19 -0000 Delivered-To: apmail-hadoop-mapreduce-issues-archive@hadoop.apache.org Received: (qmail 45514 invoked by uid 500); 6 Jan 2010 02:26:18 -0000 Mailing-List: contact mapreduce-issues-help@hadoop.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: mapreduce-issues@hadoop.apache.org Delivered-To: mailing list mapreduce-issues@hadoop.apache.org Received: (qmail 45504 invoked by uid 99); 6 Jan 2010 02:26:18 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 06 Jan 2010 02:26:18 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.140] (HELO brutus.apache.org) (140.211.11.140) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 06 Jan 2010 02:26:15 +0000 Received: from brutus.apache.org (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id 670B4234C1EF for ; Tue, 5 Jan 2010 18:25:54 -0800 (PST) Message-ID: <251828317.59211262744754421.JavaMail.jira@brutus.apache.org> Date: Wed, 6 Jan 2010 02:25:54 +0000 (UTC) From: "Leonid Furman (JIRA)" To: mapreduce-issues@hadoop.apache.org Subject: [jira] Updated: (MAPREDUCE-1327) Oracle database import via sqoop fails when a table contains the column types such as TIMESTAMP(6) WITH LOCAL TIME ZONE and TIMESTAMP(6) WITH TIME ZONE In-Reply-To: <129734234.1261521149463.JavaMail.jira@brutus> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 X-Virus-Checked: Checked by ClamAV on apache.org [ https://issues.apache.org/jira/browse/MAPREDUCE-1327?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Leonid Furman updated MAPREDUCE-1327: ------------------------------------- Attachment: MAPREDUCE-1327.patch.gz > Oracle database import via sqoop fails when a table contains the column types such as TIMESTAMP(6) WITH LOCAL TIME ZONE and TIMESTAMP(6) WITH TIME ZONE > ------------------------------------------------------------------------------------------------------------------------------------------------------- > > Key: MAPREDUCE-1327 > URL: https://issues.apache.org/jira/browse/MAPREDUCE-1327 > Project: Hadoop Map/Reduce > Issue Type: Bug > Components: contrib/sqoop > Affects Versions: 0.22.0 > Reporter: Leonid Furman > Fix For: 0.22.0 > > Attachments: MAPREDUCE-1327.patch.gz > > Original Estimate: 96h > Remaining Estimate: 96h > > When Oracle table contains the columns "TIMESTAMP(6) WITH LOCAL TIME ZONE" and "TIMESTAMP(6) WITH TIME ZONE", Sqoop fails to map values for those columns to valid Java data types, resulting in the following exception: > ERROR sqoop.Sqoop: Got exception running Sqoop: java.lang.NullPointerException > java.lang.NullPointerException > at org.apache.hadoop.sqoop.orm.ClassWriter.generateFields(ClassWriter.java:253) > at org.apache.hadoop.sqoop.orm.ClassWriter.generateClassForColumns(ClassWriter.java:701) > at org.apache.hadoop.sqoop.orm.ClassWriter.generate(ClassWriter.java:597) > at org.apache.hadoop.sqoop.Sqoop.generateORM(Sqoop.java:75) > at org.apache.hadoop.sqoop.Sqoop.importTable(Sqoop.java:87) > at org.apache.hadoop.sqoop.Sqoop.run(Sqoop.java:175) > at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65) > at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:79) > at org.apache.hadoop.sqoop.Sqoop.main(Sqoop.java:201) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > I have modified the code for Hadoop and Sqoop so this bug is fixed on my machine. Please let me know if you would like me to generate the patch and upload it to this ticket. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.