sqoop-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andy Skelton (JIRA)" <j...@apache.org>
Subject [jira] [Created] (SQOOP-1341) Sqoop Export Upsert for MySQL lacks batch support
Date Wed, 25 Jun 2014 02:42:24 GMT
Andy Skelton created SQOOP-1341:
-----------------------------------

             Summary: Sqoop Export Upsert for MySQL lacks batch support
                 Key: SQOOP-1341
                 URL: https://issues.apache.org/jira/browse/SQOOP-1341
             Project: Sqoop
          Issue Type: Improvement
          Components: connectors/mysql
    Affects Versions: 1.4.4
            Reporter: Andy Skelton
             Fix For: 1.4.5


MySQL export upserts are limited to one row per statement. This wastes bandwidth and makes
the exports unusably slow.

I wrote a patch to support multiple rows per statement at (https://github.com/cloudera/sqoop/pull/22/files).
Now the records.per.statement parameter actually works, and I get fast exports (60k rows/sec)
with 1000 records per statement, 10 statements per transactions, and 5 mappers.



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Mime
View raw message