[SQOOP-1341] Sqoop Export Upsert for MySQL lacks batch support

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.4.4
• Fix Version/s: 1.4.5
• Component/s: connectors/mysql
• Labels: easyfix newbie patch
• Assignee: Andy Skelton
• Reporter: Andy Skelton
• Created: 25/Jun/14 02:42
• Updated: 29/Jun/14 00:54
• Resolved: 28/Jun/14 23:44

Description

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.