[HIVE-17891] HIVE-13076 uses create table if not exists for the postgres script

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.3.2, 2.4.0, 3.0.0
• Assignee: Vihang Karajgaonkar
• Reporter: Vihang Karajgaonkar
• Created: 24/Oct/17 19:23
• Updated: 22/May/18 23:13
• Resolved: 30/Oct/17 17:14

Description

HIVE-13076 addes a new table to the schema but the patch script uses CREATE TABLE IF NOT EXISTS syntax to add the new table. The issue is that the IF NOT EXISTS clause is only available from postgres 9.1 onwards. So the script will fail for older versions of postgres.