drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Abhishek Girish (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-2317) UNION ALL on sub-queries with single column projection fails on GROUP BY
Date Thu, 26 Feb 2015 02:28:04 GMT
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)

Mime
View raw message