You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Hive QA (JIRA)" <ji...@apache.org> on 2014/03/06 11:48:57 UTC

[jira] [Commented] (HIVE-6551) group by after join with skew join optimization references invalid task sometimes

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

Hive QA commented on HIVE-6551:
-------------------------------



{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/12632789/HIVE-6551.1.patch.txt

{color:red}ERROR:{color} -1 due to 3 failed/errored test(s), 5358 tests executed
*Failed tests:*
{noformat}
org.apache.hadoop.hive.cli.TestMinimrCliDriver.testCliDriver_bucket5
org.apache.hive.beeline.TestSchemaTool.testSchemaInit
org.apache.hive.beeline.TestSchemaTool.testSchemaUpgrade
{noformat}

Test results: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/1637/testReport
Console output: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/1637/console

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: 3 tests failed
{noformat}

This message is automatically generated.

ATTACHMENT ID: 12632789

> group by after join with skew join optimization references invalid task sometimes
> ---------------------------------------------------------------------------------
>
>                 Key: HIVE-6551
>                 URL: https://issues.apache.org/jira/browse/HIVE-6551
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Navis
>            Assignee: Navis
>            Priority: Trivial
>         Attachments: HIVE-6551.1.patch.txt
>
>
> For example,
> {noformat}
> hive> set hive.auto.convert.join = true;
> hive> set hive.optimize.skewjoin = true;
> hive> set hive.skewjoin.key = 3;
> hive> 
>     > EXPLAIN FROM 
>     > (SELECT src.* FROM src) x
>     > JOIN 
>     > (SELECT src.* FROM src) Y
>     > ON (x.key = Y.key)
>     > SELECT sum(hash(Y.key)), sum(hash(Y.value));
> OK
> STAGE DEPENDENCIES:
>   Stage-8 is a root stage
>   Stage-6 depends on stages: Stage-8
>   Stage-5 depends on stages: Stage-6 , consists of Stage-4, Stage-2
>   Stage-4
>   Stage-2 depends on stages: Stage-4, Stage-1
>   Stage-0 is a root stage
> ...
> {noformat}
> Stage-2 references not-existing Stage-1



--
This message was sent by Atlassian JIRA
(v6.2#6252)