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