Type: New Feature
Affects Version/s: 1.4.3
Fix Version/s: None
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:
A similar request to add upsert functionality for MySQL was addressed here: