You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Abhishek Girish (JIRA)" <ji...@apache.org> on 2015/02/26 03:28:04 UTC
[jira] [Created] (DRILL-2317) UNION ALL on sub-queries with single
column projection fails on GROUP BY
Abhishek Girish created DRILL-2317:
--------------------------------------
Summary: 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: Jinfeng Ni
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)