Abhishek Girish created DRILL-2376: -------------------------------------- Summary: 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 fails to execute: {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} -- This message was sent by Atlassian JIRA (v6.3.4#6332)