You are viewing a plain text version of this content. The canonical link for it is here.
Posted to mapreduce-issues@hadoop.apache.org by "Aaron Kimball (JIRA)" <ji...@apache.org> on 2010/02/05 01:32:27 UTC

[jira] Created: (MAPREDUCE-1460) Oracle support in DataDrivenDBInputFormat

Oracle support in DataDrivenDBInputFormat
-----------------------------------------

                 Key: MAPREDUCE-1460
                 URL: https://issues.apache.org/jira/browse/MAPREDUCE-1460
             Project: Hadoop Map/Reduce
          Issue Type: Improvement
          Components: contrib/sqoop
            Reporter: Aaron Kimball
            Assignee: Aaron Kimball


DataDrivenDBInputFormat does not work with Oracle due to various SQL syntax issues.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (MAPREDUCE-1460) Oracle support in DataDrivenDBInputFormat

Posted by "Aaron Kimball (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/MAPREDUCE-1460?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Aaron Kimball updated MAPREDUCE-1460:
-------------------------------------

    Attachment: MAPREDUCE-1460.patch

This patch provides support for Oracle via OracleDataDrivenDBInputFormat which subclasses DataDrivenDBInputFormat. This overrides the {{getRecordReader()}} and {{getSplitter()}} methods to return Oracle-specific versions (included in this patch) where appropriate.

This patch also updates Sqoop to use this InputFormat. With that, all Sqoop MapReduce jobs use the new API, so the {{org.apache.hadoop.sqoop.mapred}} package and its associated tests are all removed.

> Oracle support in DataDrivenDBInputFormat
> -----------------------------------------
>
>                 Key: MAPREDUCE-1460
>                 URL: https://issues.apache.org/jira/browse/MAPREDUCE-1460
>             Project: Hadoop Map/Reduce
>          Issue Type: Improvement
>          Components: contrib/sqoop
>            Reporter: Aaron Kimball
>            Assignee: Aaron Kimball
>         Attachments: MAPREDUCE-1460.patch
>
>
> DataDrivenDBInputFormat does not work with Oracle due to various SQL syntax issues.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Commented: (MAPREDUCE-1460) Oracle support in DataDrivenDBInputFormat

Posted by "Hudson (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/MAPREDUCE-1460?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12847728#action_12847728 ] 

Hudson commented on MAPREDUCE-1460:
-----------------------------------

Integrated in Hadoop-Mapreduce-trunk-Commit #285 (See [http://hudson.zones.apache.org/hudson/job/Hadoop-Mapreduce-trunk-Commit/285/])
    

> Oracle support in DataDrivenDBInputFormat
> -----------------------------------------
>
>                 Key: MAPREDUCE-1460
>                 URL: https://issues.apache.org/jira/browse/MAPREDUCE-1460
>             Project: Hadoop Map/Reduce
>          Issue Type: Improvement
>          Components: contrib/sqoop
>            Reporter: Aaron Kimball
>            Assignee: Aaron Kimball
>             Fix For: 0.22.0
>
>         Attachments: MAPREDUCE-1460.patch
>
>
> DataDrivenDBInputFormat does not work with Oracle due to various SQL syntax issues.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (MAPREDUCE-1460) Oracle support in DataDrivenDBInputFormat

Posted by "Tom White (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/MAPREDUCE-1460?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Tom White updated MAPREDUCE-1460:
---------------------------------

       Resolution: Fixed
    Fix Version/s: 0.22.0
     Hadoop Flags: [Reviewed]
           Status: Resolved  (was: Patch Available)

I've just committed this. Thanks Aaron!

> Oracle support in DataDrivenDBInputFormat
> -----------------------------------------
>
>                 Key: MAPREDUCE-1460
>                 URL: https://issues.apache.org/jira/browse/MAPREDUCE-1460
>             Project: Hadoop Map/Reduce
>          Issue Type: Improvement
>          Components: contrib/sqoop
>            Reporter: Aaron Kimball
>            Assignee: Aaron Kimball
>             Fix For: 0.22.0
>
>         Attachments: MAPREDUCE-1460.patch
>
>
> DataDrivenDBInputFormat does not work with Oracle due to various SQL syntax issues.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (MAPREDUCE-1460) Oracle support in DataDrivenDBInputFormat

Posted by "Aaron Kimball (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/MAPREDUCE-1460?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Aaron Kimball updated MAPREDUCE-1460:
-------------------------------------

    Status: Patch Available  (was: Open)

> Oracle support in DataDrivenDBInputFormat
> -----------------------------------------
>
>                 Key: MAPREDUCE-1460
>                 URL: https://issues.apache.org/jira/browse/MAPREDUCE-1460
>             Project: Hadoop Map/Reduce
>          Issue Type: Improvement
>          Components: contrib/sqoop
>            Reporter: Aaron Kimball
>            Assignee: Aaron Kimball
>         Attachments: MAPREDUCE-1460.patch
>
>
> DataDrivenDBInputFormat does not work with Oracle due to various SQL syntax issues.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Commented: (MAPREDUCE-1460) Oracle support in DataDrivenDBInputFormat

Posted by "Hadoop QA (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/MAPREDUCE-1460?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12847233#action_12847233 ] 

Hadoop QA commented on MAPREDUCE-1460:
--------------------------------------

+1 overall.  Here are the results of testing the latest attachment 
  http://issues.apache.org/jira/secure/attachment/12434907/MAPREDUCE-1460.patch
  against trunk revision 925040.

    +1 @author.  The patch does not contain any @author tags.

    +1 tests included.  The patch appears to include 19 new or modified tests.

    +1 javadoc.  The javadoc tool did not generate any warning messages.

    +1 javac.  The applied patch does not increase the total number of javac compiler warnings.

    +1 findbugs.  The patch does not introduce any new Findbugs warnings.

    +1 release audit.  The applied patch does not increase the total number of release audit warnings.

    +1 core tests.  The patch passed core unit tests.

    +1 contrib tests.  The patch passed contrib unit tests.

Test results: http://hudson.zones.apache.org/hudson/job/Mapreduce-Patch-h4.grid.sp2.yahoo.net/39/testReport/
Findbugs warnings: http://hudson.zones.apache.org/hudson/job/Mapreduce-Patch-h4.grid.sp2.yahoo.net/39/artifact/trunk/build/test/findbugs/newPatchFindbugsWarnings.html
Checkstyle results: http://hudson.zones.apache.org/hudson/job/Mapreduce-Patch-h4.grid.sp2.yahoo.net/39/artifact/trunk/build/test/checkstyle-errors.html
Console output: http://hudson.zones.apache.org/hudson/job/Mapreduce-Patch-h4.grid.sp2.yahoo.net/39/console

This message is automatically generated.

> Oracle support in DataDrivenDBInputFormat
> -----------------------------------------
>
>                 Key: MAPREDUCE-1460
>                 URL: https://issues.apache.org/jira/browse/MAPREDUCE-1460
>             Project: Hadoop Map/Reduce
>          Issue Type: Improvement
>          Components: contrib/sqoop
>            Reporter: Aaron Kimball
>            Assignee: Aaron Kimball
>         Attachments: MAPREDUCE-1460.patch
>
>
> DataDrivenDBInputFormat does not work with Oracle due to various SQL syntax issues.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Commented: (MAPREDUCE-1460) Oracle support in DataDrivenDBInputFormat

Posted by "Hudson (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/MAPREDUCE-1460?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12847785#action_12847785 ] 

Hudson commented on MAPREDUCE-1460:
-----------------------------------

Integrated in Hadoop-Mapreduce-trunk #264 (See [http://hudson.zones.apache.org/hudson/job/Hadoop-Mapreduce-trunk/264/])
    . Oracle support in DataDrivenDBInputFormat. Contributed by Aaron Kimball.


> Oracle support in DataDrivenDBInputFormat
> -----------------------------------------
>
>                 Key: MAPREDUCE-1460
>                 URL: https://issues.apache.org/jira/browse/MAPREDUCE-1460
>             Project: Hadoop Map/Reduce
>          Issue Type: Improvement
>          Components: contrib/sqoop
>            Reporter: Aaron Kimball
>            Assignee: Aaron Kimball
>             Fix For: 0.22.0
>
>         Attachments: MAPREDUCE-1460.patch
>
>
> DataDrivenDBInputFormat does not work with Oracle due to various SQL syntax issues.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.