[
https://issues.apache.org/jira/browse/TAJO-2082?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15179495#comment-15179495
]
ASF GitHub Bot commented on TAJO-2082:
--------------------------------------
Github user jihoonson commented on the pull request:
https://github.com/apache/tajo/pull/969#issuecomment-192150416
Thank you for the review.
> 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.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)
