[IMPALA-4340] validate postgres 9.5 for random query generator reference database

• Type: Sub-task
• Status: Resolved
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: Impala 2.8.0
• Fix Version/s: Impala 2.8.0
• Component/s: Infrastructure
• Target Version: Kudu_Impala
• Assignee: Michael Brown
• Reporter: Michael Brown
• Created: 21/Oct/16 22:08
• Updated: 01/Nov/16 16:10
• Resolved: 01/Nov/16 16:10

Description

Currently, the random query generator is run against postgres 9.3 for a reference database, but it needs postgres 9.5 features to better verify Impala/Kudu functionality. Specifically it's the ON CONFLICT clause here https://www.postgresql.org/docs/9.5/static/sql-insert.html . This is needed both to handle INSERT with implied IGNORE, which Impala will do, and UPSERT.

The validation should show that data migration and loading and query execution and comparison is possible. It's mostly a smoke/sanity test.