[ https://issues.apache.org/jira/browse/HIVE-17891?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16219311#comment-16219311 ]
Vihang Karajgaonkar commented on HIVE-17891: -------------------------------------------- [~ngangam] Can you please take a look? I will wait for precommit to complete but I don't think it tests schema changes anyway currently. > HIVE-13076 uses create table if not exists for the postgres script > ------------------------------------------------------------------ > > Key: HIVE-17891 > URL: https://issues.apache.org/jira/browse/HIVE-17891 > Project: Hive > Issue Type: Bug > Reporter: Vihang Karajgaonkar > Assignee: Vihang Karajgaonkar > Attachments: HIVE-17891.01.patch, HIVE-17891.02.patch > > > 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. -- This message was sent by Atlassian JIRA (v6.4.14#64029)