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

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

Jihoon Son created TAJO-2082:
--------------------------------

             Summary: 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)