hadoop-mapreduce-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Tsuyoshi Ozawa (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (MAPREDUCE-4522) DBOutputFormat Times out on large batch inserts
Date Fri, 04 Mar 2016 01:14:40 GMT

    [ https://issues.apache.org/jira/browse/MAPREDUCE-4522?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15179088#comment-15179088
] 

Tsuyoshi Ozawa commented on MAPREDUCE-4522:
-------------------------------------------

[~shyam_gav] thank you for updating. MR_DBOUTPUTFORMAT_BATCH_SIZE is DBInputFormat specific
configuration. Please add  the configuraition to MR_DBOUTPUTFORMAT_BATCH_SIZE instead of MRJobConfig.
After addressing the comment, could you attach the patch to jira?

> 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
>              Labels: newbie
>
> 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 was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message