[IMPALA-4361] qgen: support DELETE 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:10
• Updated: 13/Oct/17 22:18

Description

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

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