hadoop-mapreduce-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Manoj Babu D (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (MAPREDUCE-1290) DBOutputFormat does not support rewriteBatchedStatements when using MySQL jdbc drivers
Date Wed, 22 Aug 2012 18:02:42 GMT

     [ https://issues.apache.org/jira/browse/MAPREDUCE-1290?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Manoj Babu D updated MAPREDUCE-1290:
------------------------------------

    Attachment: MapReduce-1290-trunk.patch

Fixed the failures in the unit tests (TestConstructQuery, TestDBOutputFormat).
                
> 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, 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

        

Mime
View raw message