tajo-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hudson (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (TAJO-2082) Aggregation on a derived table which includes union can cause incorrect result
Date Fri, 04 Mar 2016 08:01:40 GMT

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

Hudson commented on TAJO-2082:
------------------------------

SUCCESS: Integrated in Tajo-0.11.2-build #177 (See [https://builds.apache.org/job/Tajo-0.11.2-build/177/])
TAJO-2082: Aggregation on a derived table which includes union can cause (jihoonson: rev 3e083b16413ba719767cb2ff5fc96567c53550d8)
* tajo-core/src/main/java/org/apache/tajo/engine/planner/global/rewriter/rules/BroadcastJoinRule.java
* tajo-common/src/main/java/org/apache/tajo/util/graph/SimpleDirectedGraph.java
* tajo-common/src/main/java/org/apache/tajo/util/graph/DirectedGraphVisitor.java
* tajo-common/src/test/java/org/apache/tajo/util/graph/TestSimpleDirectedGraph.java
* tajo-plan/src/main/java/org/apache/tajo/plan/util/PlannerUtil.java
* tajo-core/src/main/java/org/apache/tajo/querymaster/Repartitioner.java
* tajo-common/src/main/java/org/apache/tajo/util/graph/DirectedGraph.java
* tajo-core/src/main/java/org/apache/tajo/engine/planner/global/ExecutionBlock.java
* tajo-core/src/main/java/org/apache/tajo/querymaster/Stage.java
* tajo-core/src/main/java/org/apache/tajo/engine/planner/global/GlobalPlanner.java
* tajo-plan/src/main/java/org/apache/tajo/plan/rewrite/SelfDescSchemaBuildPhase.java
* CHANGES
* tajo-core/src/main/java/org/apache/tajo/engine/planner/global/builder/DistinctGroupbyBuilder.java
* tajo-core/src/main/java/org/apache/tajo/engine/planner/physical/ExternalSortExec.java
* tajo-core/src/main/java/org/apache/tajo/engine/planner/global/MasterPlan.java
* tajo-core/src/main/java/org/apache/tajo/engine/planner/global/DataChannel.java
* tajo-common/src/main/java/org/apache/tajo/exception/TooLargeInputForCrossJoinException.java


> Aggregation on a derived table which includes union can cause incorrect result
> ------------------------------------------------------------------------------
>
>                 Key: TAJO-2082
>                 URL: https://issues.apache.org/jira/browse/TAJO-2082
>             Project: Tajo
>          Issue Type: Bug
>          Components: distributed query plan
>    Affects Versions: 0.11.0, 0.11.1
>            Reporter: Jihoon Son
>            Assignee: Jihoon Son
>            Priority: Blocker
>             Fix For: 0.12.0, 0.11.2
>
>
> This problem can be reproduced by running the following query on 10GB TPC-H data set.
> {noformat}
> select 
>   sum(t.cnt) as cnt, o_orderkey, o_custkey 
> from 
>   (
>     select 
>       o_orderkey, o_custkey, CAST(COUNT(1) AS INT4) as cnt 
>     from 
>       orders 
>     group by 
>       o_orderkey, o_custkey 
>     union all 
>     select 
>       o_orderkey, o_custkey, o_shippriority 
>     from 
>       orders
>   ) as t 
> group by 
>   o_orderkey, o_custkey
> {noformat}



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

Mime
View raw message