[ https://issues.apache.org/jira/browse/DRILL-2378?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Sean Hsuan-Yi Chu resolved DRILL-2378. -------------------------------------- Resolution: Pending Closed > 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.9.0 > Reporter: Abhishek Girish > Assignee: Sean Hsuan-Yi Chu > Fix For: 1.2.0 > > Attachments: drillbit.log > > > *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)