[
https://issues.apache.org/jira/browse/HIVE-20462?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16592829#comment-16592829
]
Hive QA commented on HIVE-20462:
--------------------------------
Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12937162/HIVE-20462.1.patch
{color:green}SUCCESS:{color} +1 due to 1 test(s) being added or modified.
{color:green}SUCCESS:{color} +1 due to 14897 tests passed
Test results:
https://builds.apache.org/job/PreCommit-HIVE-Build/13474/testReport
Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/13474/console
Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-13474/
Messages:
{noformat}
Executing org.apache.hive.ptest.execution.TestCheckPhase
Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.YetusPhase
Executing org.apache.hive.ptest.execution.ExecutionPhase
Executing org.apache.hive.ptest.execution.ReportingPhase
{noformat}
This message is automatically generated.
ATTACHMENT ID: 12937162 - PreCommit-HIVE-Build
> "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)
