[SQOOP-1085] Support "INSERT IGNORE INTO" statement in export job

• Type: New Feature
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.4.3
• Labels: sqoop

Environment

Linux hadoop-02 2.6.18-164.15.1.el5.centos.plusxen #1 SMP Wed Mar 17 20:32:20 EDT 2010 x86_64 x86_64 x86_64 GNU/Linux

• Assignee: David Quigley
• Reporter: David Quigley
• Created: 17/Jun/13 07:10
• Updated: 17/Jun/13 14:15

Description

Currently sqoop export job does not support INSERT IGNORE INTO syntax/use case. "Upsert mode" https://issues.apache.org/jira/browse/SQOOP-327 handles INSERT INTO ON DUPLICATE KEY UPDATE syntax/use case. The new feature will allow exporting records while not updating existing keys. In the case of duplicate records, INSERT IGNORE INTO will result in faster running export.