[
https://issues.apache.org/jira/browse/TAJO-2082?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15179490#comment-15179490
]
ASF GitHub Bot commented on TAJO-2082:
--------------------------------------
Github user asfgit closed the pull request at:
https://github.com/apache/tajo/pull/969
> 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
> Reporter: Jihoon Son
> Assignee: Jihoon Son
> Priority: Blocker
> Fix For: 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)
