hadoop-mapreduce-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Leonid Furman (JIRA)" <j...@apache.org>
Subject [jira] Commented: (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
Date Wed, 13 Jan 2010 02:33:54 GMT

    [ https://issues.apache.org/jira/browse/MAPREDUCE-1327?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12799539#action_12799539

Leonid Furman commented on MAPREDUCE-1327:

Thanks Aaron! It's been a great experience!

I also wanted to ask if this patch will be applied to Cloudera source repository any time
soon. The reason I am asking is because my HDFS cluster is running on the current Hadoop release
version - 0.20.0, which doesn't support Oracle. Therefore, if I build hadoop from trunk and
run Sqoop, it will not work. But Cloudera's latest release supports Oracle, and when this
patch MAPREDUCE-1327 is applied to Cloudera, installed on both the namenode and HDFS cluster,
Sqoop should work as expected.

Thank you in advance.

> Oracle database import via sqoop fails when a table contains the column types such as
> -------------------------------------------------------------------------------------------------------------------------------------------------------
>                 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.3.patch, MAPREDUCE-1327.4.patch, MAPREDUCE-1327.5.patch,
>   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.

View raw message