[IMPALA-4360] qgen: support UPDATE queries

• Type: Sub-task
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: Impala 2.8.0
• Component/s: Infrastructure
• Target Version: Product Backlog
• Assignee: Unassigned
• Reporter: Michael Brown
• Created: 24/Oct/16 21:08
• Updated: 13/Oct/17 22:17

Description

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

• Modify Query object to have an UPDATE statement, and implement UpdateClause.
• Modify QueryProfile to choose columns to be upserted
• Modify QueryGenerator to generate UPDATE statements
• Modify SqlWriter to write UPDATE SQL in Impala
• Modify SqlWriter to write UPDATE SQL in PostgresQL
• Hook in the same DB comparison after UPDATE that is used for INSERT