You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@hive.apache.org by "Sahil Takiar (JIRA)" <ji...@apache.org> on 2017/11/09 16:56:01 UTC

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

     [ https://issues.apache.org/jira/browse/HIVE-17891?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Sahil Takiar updated HIVE-17891:
--------------------------------
    Fix Version/s: 2.3.2

> 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, 2.3.2
>
>         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)