[
https://issues.apache.org/jira/browse/HIVE-17891?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Vihang Karajgaonkar updated HIVE-17891:
---------------------------------------
Resolution: Fixed
Fix Version/s: 2.4.0
3.0.0
Status: Resolved (was: Patch Available)
Merged to master and branch-2. Thanks for the review [~ngangam]
> 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
> Fix For: 3.0.0, 2.4.0
>
> Attachments: HIVE-17891.01.patch, HIVE-17891.02.patch,
> HIVE-17891.03.patch, HIVE-17891.04.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)
