You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Vihang Karajgaonkar (JIRA)" <ji...@apache.org> on 2017/10/24 19:24:00 UTC

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

Vihang Karajgaonkar created HIVE-17891:
------------------------------------------

             Summary: HIVE-13354 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


HIVE-13354 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 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)