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 "Nathan Jarus (JIRA)" <ji...@apache.org> on 2012/08/07 03:49:02 UTC

[jira] [Created] (MAPREDUCE-4522) DBOutputFormat Times out on large batch inserts

Nathan Jarus created MAPREDUCE-4522:
---------------------------------------

             Summary: DBOutputFormat Times out on large batch inserts
                 Key: MAPREDUCE-4522
                 URL: https://issues.apache.org/jira/browse/MAPREDUCE-4522
             Project: Hadoop Map/Reduce
          Issue Type: Bug
          Components: task-controller
    Affects Versions: 0.20.205.0
            Reporter: Nathan Jarus


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. 

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira