You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "static-max (JIRA)" <ji...@apache.org> on 2018/08/25 09:17:00 UTC
[jira] [Updated] (HIVE-20462) "CREATE VIEW IF NOT EXISTS" fails if
view already exists
[ https://issues.apache.org/jira/browse/HIVE-20462?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
static-max updated HIVE-20462:
------------------------------
Summary: "CREATE VIEW IF NOT EXISTS" fails if view already exists (was: "CREATE VIEW IF NOT EXISTS" fails view already exists)
> "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
> Components: Hive
> Affects Versions: 3.1.0
> Environment: HDP 3.0
> Hive 3.1.0.3.0.0.0-1634
> Reporter: static-max
> Priority: Major
>
> 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)