hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Daniel Dai (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-20462) "CREATE VIEW IF NOT EXISTS" fails if view already exists
Date Sun, 26 Aug 2018 06:40:00 GMT

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

Daniel Dai updated HIVE-20462:
------------------------------
    Status: Patch Available  (was: Open)

Likely to be broken by HIVE-14487.

> "CREATE VIEW IF NOT EXISTS" fails if view already exists
> --------------------------------------------------------
>
>                 Key: HIVE-20462
>                 URL: https://issues.apache.org/jira/browse/HIVE-20462
>             Project: Hive
>          Issue Type: Bug
>    Affects Versions: 3.1.0
>         Environment: HDP 3.0
> Hive 3.1.0.3.0.0.0-1634
>            Reporter: static-max
>            Assignee: Daniel Dai
>            Priority: Major
>         Attachments: HIVE-20462.1.patch
>
>
> After upgrading to Hive 3.1 from Hive 1.2, I can't run my queries anymore. It seems that
"if not exists" is ignored in "create view".
> *Example:*
>  # create view if not exists test as select 1;
>  # create view if not exists test as select 1;
> The second call fails with "Table already exists: default.test". I changed this to "create
or replace view" as a workaround.
> Also documented [link here|https://community.hortonworks.com/questions/214772/hdp-3-hive-create-view-if-not-exists-fails.html|]



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message