[SQOOP-1270] Sqoop PostgreSQL Export Upsert Functionality Request

• Type: New Feature
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.4.3
• Component/s: connectors/postgresql

Environment

CDH 4.5

• Assignee: Unassigned
• Reporter: Hari Sekhon
• Created: 21/Jan/14 11:08
• Updated: 24/Jun/16 21:43

Description

Hi,

One of my Hadoop developers is trying to re-export to PostgreSQL but is hitting the following error:

ERROR tool.ExportTool: Error during export: Mixed update/insert is not supported against the target database yet

Could we please add upsert functionality to the PostgreSQL connector?

Although Postgres doesn't have direct upsert functionality it's possible to construct SQL to handle this like so:

http://www.postgresql.org/docs/current/static/plpgsql-control-structures.html#PLPGSQL-UPSERT-EXAMPLE

A similar request to add upsert functionality for MySQL was addressed here:

https://issues.apache.org/jira/browse/SQOOP-621

Thanks

Hari Sekhon
http://www.linkedin.com/in/harisekhon