[ https://issues.apache.org/jira/browse/DRILL-2317?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Sean Hsuan-Yi Chu updated DRILL-2317: ------------------------------------- Fix Version/s: 0.8.0 > UNION ALL on sub-queries with single column projection fails on GROUP BY > ------------------------------------------------------------------------ > > Key: DRILL-2317 > URL: https://issues.apache.org/jira/browse/DRILL-2317 > Project: Apache Drill > Issue Type: Bug > Components: Query Planning & Optimization > Affects Versions: 0.8.0 > Reporter: Abhishek Girish > Assignee: Sean Hsuan-Yi Chu > Fix For: 0.8.0 > > > A UNION ALL on two sub-queries with only a single column projected, and GROUP > BY on the whole query fails with an IndexOutOfBoundsException > *The following query fails to execute:* > {code:sql} > SELECT c1 > FROM ((SELECT ss_quantity AS c1 > FROM store_sales limit 1) > UNION ALL > (SELECT ws_quantity AS c2 > FROM web_sales limit 1) > ) foo > GROUP BY c1; > {code} > *The following query also fails to execute:* > {code:sql} > SELECT distinct(c) > FROM ((SELECT ss_quantity AS c > FROM store_sales limit 1) > UNION ALL > (SELECT ws_quantity AS c > FROM web_sales limit 1) > ) ; > {code} > Error: > Query failed: RemoteRpcException: Failure while running fragment., index: 0, > length: 1 (expected: range(0, 0)) > LOG message indicates java.lang.IndexOutOfBoundsException > *The following query executes fine:* > {code:sql} > SELECT c1 > FROM ((SELECT ss_quantity AS c1, ss_item_sk c3 > FROM store_sales limit 1) > UNION ALL > (SELECT ws_quantity AS c2, ws_item_sk c4 > FROM web_sales limit 1) > ) foo > GROUP BY c1; > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)