[MAPREDUCE-716] org.apache.hadoop.mapred.lib.db.DBInputformat not working with oracle

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.21.0

Environment

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

• Hadoop Flags: Reviewed
• Assignee: Aaron Kimball
• Reporter: evanand
• Created: 12/Mar/09 21:48
• Updated: 24/Aug/10 21:14
• Resolved: 21/Jul/09 16:13

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

Issue Links

• is cloned by: MAPREDUCE-487 DBInputFormat support for Oracle
• is related to: MAPREDUCE-792 javac warnings in DBInputFormat