[ https://issues.apache.org/jira/browse/DRILL-2378?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14355941#comment-14355941 ]
Sean Hsuan-Yi Chu commented on DRILL-2378: ------------------------------------------ Resolved in commit #: 0368adf0c > 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 > 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)