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 "Hadoop QA (JIRA)" <ji...@apache.org> on 2012/08/22 20:22:42 UTC
[jira] [Commented] (MAPREDUCE-1290) DBOutputFormat does not support
rewriteBatchedStatements when using MySQL jdbc drivers
[ https://issues.apache.org/jira/browse/MAPREDUCE-1290?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13439737#comment-13439737 ]
Hadoop QA commented on MAPREDUCE-1290:
--------------------------------------
-1 overall. Here are the results of testing the latest attachment
http://issues.apache.org/jira/secure/attachment/12542003/MapReduce-1290-trunk.patch
against trunk revision .
-1 patch. The patch command could not apply the patch.
Console output: https://builds.apache.org/job/PreCommit-MAPREDUCE-Build/2758//console
This message is automatically generated.
> DBOutputFormat does not support rewriteBatchedStatements when using MySQL jdbc drivers
> --------------------------------------------------------------------------------------
>
> Key: MAPREDUCE-1290
> URL: https://issues.apache.org/jira/browse/MAPREDUCE-1290
> Project: Hadoop Map/Reduce
> Issue Type: Bug
> Affects Versions: 0.20.1
> Reporter: Joe Crobak
> Labels: DBOutoutFormat, patch
> Attachments: MAPREDUCE-1290.patch, MapReduce-1290-trunk.patch
>
>
> The DBOutputFormat adds a semi-colon to the end of the INSERT statement that it uses to save fields to the database. Semicolons are typically used in command line programs but are not needed when using the JDBC API. In this case, the stray semi-colon breaks rewriteBatchedStatement support. See: http://forums.mysql.com/read.php?39,271526,271526#msg-271526 for an example.
> In my use case, rewriteBatchedStatement is very useful because it increases the speed of inserts and reduces memory consumption.
--
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