[IMPALA-4359] qgen: add UPSERT support

• Type: Sub-task
• Status: Resolved
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: Impala 2.8.0
• Fix Version/s: Impala 2.9.0
• Component/s: Infrastructure
• Target Version: Kudu_Impala
• Assignee: Michael Brown
• Reporter: Michael Brown
• Created: 24/Oct/16 21:06
• Updated: 06/Feb/17 17:00
• Resolved: 06/Feb/17 17:00

Description

After all the INSERT upfront work, UPSERT should be relatively straightforward.

• Modify Query object to have an UPSERT statement, and implement UpsertClause.
• Modify QueryProfile to choose columns to be upserted
• Modify QueryGenerator to generate UPSERT statements
• Modify SqlWriter to write UPSERT SQL in Impala
• Modify SqlWriter to write UPSERT SQL in PostgresQL. Note this is really “INSERT ... ON CONFLICT DO UPDATE”.
• Hook in the same DB comparison after UPSERT that is used for INSERT