[ https://issues.apache.org/jira/browse/DRILL-2376?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14347495#comment-14347495 ]
Sean Hsuan-Yi Chu commented on DRILL-2376: ------------------------------------------ This one is very similar to DRILL-1977. Essentially, the old Union-All lets the Aggregate see only one side of Union-All's input even if they have the same output column name. > UNION ALL on Aggregates with GROUP BY returns incomplete results > ---------------------------------------------------------------- > > Key: DRILL-2376 > URL: https://issues.apache.org/jira/browse/DRILL-2376 > Project: Apache Drill > Issue Type: Bug > Components: Query Planning & Optimization > Affects Versions: 0.8.0 > Reporter: Abhishek Girish > Assignee: Jinfeng Ni > > The following query returns incomplete results: > {code:sql} > select x > from > (SELECT Sum(ss_ext_sales_price) x > FROM store_sales > UNION ALL > SELECT Sum(cs_ext_sales_price) x > FROM catalog_sales) tmp > GROUP BY x; > Results from Drill: > +------------+ > | x | > +------------+ > | 3658019159.35 | > +------------+ > 1 row selected (3.474 seconds) > Results from Postgres: > x > --------------- > 5265207074.51 > 3658019159.35 > (2 rows) > {code} > Removing GROUP BY returns the right results: > {code:sql} > select x > from > (SELECT Sum(ss_ext_sales_price) x > FROM store_sales > UNION ALL > SELECT Sum(cs_ext_sales_price) x > FROM catalog_sales) tmp; > Results from Drill: > +------------+ > | x | > +------------+ > | 5265207074.51 | > | 3658019159.35 | > +------------+ > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)