hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Vihang Karajgaonkar (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-17891) HIVE-13076 uses create table if not exists for the postgres script
Date Wed, 25 Oct 2017 19:13:00 GMT

    [ 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)

Mime
View raw message