hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hive QA (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-8625) Some union queries result in plans with many unions with CBO on
Date Wed, 29 Oct 2014 18:40:34 GMT

    [ https://issues.apache.org/jira/browse/HIVE-8625?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14188770#comment-14188770
] 

Hive QA commented on HIVE-8625:
-------------------------------



{color:red}Overall{color}: -1 at least one tests failed

Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12677919/HIVE-8625.patch

{color:red}ERROR:{color} -1 due to 2 failed/errored test(s), 6588 tests executed
*Failed tests:*
{noformat}
org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver_optimize_nullscan
org.apache.hive.minikdc.TestJdbcWithMiniKdc.testNegativeTokenAuth
{noformat}

Test results: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/1529/testReport
Console output: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/1529/console
Test logs: http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-1529/

Messages:
{noformat}
Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.ExecutionPhase
Executing org.apache.hive.ptest.execution.ReportingPhase
Tests exited with: TestsFailedException: 2 tests failed
{noformat}

This message is automatically generated.

ATTACHMENT ID: 12677919 - PreCommit-HIVE-TRUNK-Build

> Some union queries result in plans with many unions with CBO on
> ---------------------------------------------------------------
>
>                 Key: HIVE-8625
>                 URL: https://issues.apache.org/jira/browse/HIVE-8625
>             Project: Hive
>          Issue Type: Bug
>          Components: CBO
>    Affects Versions: 0.14.0
>            Reporter: Jesús Camacho Rodríguez
>            Priority: Minor
>             Fix For: 0.14.0
>
>         Attachments: HIVE-8625.patch
>
>
> For some queries e.g. union9, union16, we are getting plans with many binary unions when
CBO is on. The reason is that an identity select operator is introduced after each union by
the CBO; thus, the method that was merging the unions when the translation of the AST into
a logical plan was being done is not executed, as it does not detect there is another union
operator. 
> With the fix in the patch attached, the method will merge the two unions if (1) one is
the child of the other one, or (2) if one is a descendant of the other one and there is an
identity select operator between them.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message