hadoop-mapreduce-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Joe Crobak (JIRA)" <j...@apache.org>
Subject [jira] Created: (MAPREDUCE-1290) DBOutputFormat does not support rewriteBatchedStatements when using MySQL jdbc drivers
Date Sat, 12 Dec 2009 19:51:18 GMT
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.


Mime
View raw message