Hari Sekhon created SQOOP-1270:
----------------------------------
Summary: Sqoop PostgreSQL Export Upsert Functionality Request
Key: SQOOP-1270
URL: https://issues.apache.org/jira/browse/SQOOP-1270
Project: Sqoop
Issue Type: New Feature
Components: connectors/postgresql
Affects Versions: 1.4.3
Environment: CDH 4.5
Reporter: Hari Sekhon
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
--
This message was sent by Atlassian JIRA
(v6.1.5#6160)
