Abhishek Girish created DRILL-2378: -------------------------------------- Summary: UNION ALL on Aggregates with GROUP BY and ORDER BY fails when column aliases don't match Key: DRILL-2378 URL: https://issues.apache.org/jira/browse/DRILL-2378 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) y FROM catalog_sales) tmp GROUP BY x ORDER BY x; Error from Drill: Query failed: RemoteRpcException: Failure while running fragment., Failure while reading vector. Expected vector class of org.apache.drill.exec.vector.Decimal38SparseVector but was holding vector class org.apache.drill.exec.vector.NullableIntVector. [ 7cc962d6-569b-44f6-9118-d5cc5a9632d9 on abhi7.qa.lab:31010 ] [ 7cc962d6-569b-44f6-9118-d5cc5a9632d9 on abhi7.qa.lab:31010 ] java.lang.RuntimeException: java.sql.SQLException: Failure while executing query. at sqlline.SqlLine$IncrementalRows.hasNext(SqlLine.java:2514) ... {code} Log snippet attached. *The following query executes fine (although returns incomplete results - see DRILL-2376:* {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 ORDER BY x; {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)