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
Reporter: Joe Crobak
Attachments: MAPREDUCE-1290.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.
-
You can reply to this email to add a comment to the issue online.
