[MAPREDUCE-4522] DBOutputFormat Times out on large batch inserts

• Type: Bug
• Status: Patch Available
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 0.20.205.0
• Component/s: task-controller
• Labels: newbie
• Assignee: Shyam Gavulla
• Reporter: Nathan Jarus
• Created: 07/Aug/12 01:48
• Updated: 25/Jul/16 04:58

Description

In DBRecordWriter#close(), progress is never updated. In large batch inserts, this can cause the reduce task to time out due to the amount of time it takes the SQL engine to process that insert.

Potential solutions I can see:
Don't batch inserts; do the insert when DBRecordWriter#write() is called (awful)
Spin up a thread in DBRecordWriter#close() and update progress in that. (gross)

I can provide code for either if you're interested.