[
https://issues.apache.org/jira/browse/TAJO-2082?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jihoon Son resolved TAJO-2082.
------------------------------
Resolution: Fixed
Fix Version/s: 0.12.0
> 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)
