Uploaded image for project: 'Hadoop Map/Reduce'
  1. Hadoop Map/Reduce
  2. MAPREDUCE-716

org.apache.hadoop.mapred.lib.db.DBInputformat not working with oracle

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.21.0
    • Component/s: None
    • Labels:
      None
    • Environment:

      Java 1.6, HAdoop0.19.0, Linux..Oracle,

    • Hadoop Flags:
      Reviewed

      Description

      org.apache.hadoop.mapred.lib.db.DBInputformat not working with oracle.

      The out of the box implementation of the Hadoop is working properly with mysql/hsqldb, but NOT with oracle.
      Reason is DBInputformat is implemented with mysql/hsqldb specific query constructs like "LIMIT", "OFFSET".

      FIX:
      building a database provider specific logic based on the database providername (which we can get using connection).

      I HAVE ALREADY IMPLEMENTED IT FOR ORACLE...READY TO CHECK_IN CODE

        Attachments

        1. HADOOP-5482.20-branch.patch
          5 kB
          Aaron Kimball
        2. HADOOP-5482.patch
          5 kB
          evanand
        3. HADOOP-5482.trunk.patch
          6 kB
          Aaron Kimball
        4. MAPREDUCE-716.2.branch20.patch
          12 kB
          Aaron Kimball
        5. MAPREDUCE-716.2.trunk.patch
          13 kB
          Aaron Kimball
        6. MAPREDUCE-716.3.trunk.patch
          18 kB
          Aaron Kimball
        7. MAPREDUCE-716.4.branch20.patch
          12 kB
          Aaron Kimball
        8. MAPREDUCE-716.4.trunk.patch
          24 kB
          Aaron Kimball

          Issue Links

            Activity

              People

              • Assignee:
                kimballa Aaron Kimball
                Reporter:
                evanand evanand
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 24h
                  24h
                  Remaining:
                  Remaining Estimate - 24h
                  24h
                  Logged:
                  Time Spent - Not Specified
                  Not Specified