[DRILL-2317] UNION ALL on sub-queries with single column projection fails on GROUP BY

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.8.0
• Fix Version/s: 0.8.0
• Component/s: Query Planning & Optimization
• Assignee: Sean Hsuan-Yi Chu
• Reporter: Abhishek Girish
• Created: 26/Feb/15 02:27
• Updated: 24/Apr/15 13:50
• Resolved: 10/Mar/15 17:14

Description

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:

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;

The following query also fails to execute:

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)
        ) ;

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:

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;

Issue Links

• depends upon: DRILL-2207 Fix Union All Operator