Return-Path: Delivered-To: apmail-hadoop-mapreduce-issues-archive@minotaur.apache.org Received: (qmail 43142 invoked from network); 22 Dec 2009 22:32:52 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 22 Dec 2009 22:32:52 -0000 Received: (qmail 78950 invoked by uid 500); 22 Dec 2009 22:32:52 -0000 Delivered-To: apmail-hadoop-mapreduce-issues-archive@hadoop.apache.org Received: (qmail 78924 invoked by uid 500); 22 Dec 2009 22:32:52 -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 78914 invoked by uid 99); 22 Dec 2009 22:32:51 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 22 Dec 2009 22:32:51 +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; Tue, 22 Dec 2009 22:32:50 +0000 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id 74D59234C045 for ; Tue, 22 Dec 2009 14:32:29 -0800 (PST) Message-ID: <129734234.1261521149463.JavaMail.jira@brutus> Date: Tue, 22 Dec 2009 22:32:29 +0000 (UTC) From: "Leonid Furman (JIRA)" To: mapreduce-issues@hadoop.apache.org Subject: [jira] Created: (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 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 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 Reporter: Leonid Furman Fix For: 0.22.0 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.