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)
