[HADOOP-4955] Make DBOutputFormat us column names from setOutput(...)

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.19.0
• Fix Version/s: 0.19.1

Environment

Ubuntu 8.04, Java 6, MySQL 5.0 (most likely not relevant)

• Hadoop Flags: Reviewed
• Assignee: Kevin Peterson
• Reporter: Kevin Peterson
• Created: 30/Dec/08 01:51
• Updated: 08/Jul/09 16:53
• Resolved: 28/Jan/09 13:50

Description

In org.apache.hadoop.mapred.lib.db.DBOutputFormat, the supplied names of the columns are not used for inserting values. The column names supplied to DBOutputFormat.setOutput(JobConf, String, String...) are used to determine the number of values to insert, but the order is dictated by the table definition of the underlying database. This affects the correct indices for DBWritable.write(PreparedStatement).

I will attach a patch that correctly maps these values.

I am characterizing this as a bug rather than an improvement because there may be existing code which implicitly relied on DBOutputFormat ignoring the supplied table names.