[
https://issues.apache.org/jira/browse/MAPREDUCE-1290?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14535240#comment-14535240
]
Ravi Prakash commented on MAPREDUCE-1290:
-----------------------------------------
The tests mentioned in the comments and TestDBOutputFormat passes without the
patch just fine. I'm guessing we have upgraded our dependencies since 2012 to
include versions with the fix. Closing as fixed. Please reopen if you disagree
> 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.003.patch, 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 was sent by Atlassian JIRA
(v6.3.4#6332)
