[jira] [Resolved] (TAJO-2082) Aggregation on a derived table which includes union can cause incorrect result

["Jihoon Son (JIRA)" <ji...@apache.org>]

     [ 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)