[DRILL-2378] UNION ALL on Aggregates with GROUP BY and ORDER BY fails when column aliases don't match

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Pending Closed
• Affects Version/s: 0.9.0
• Fix Version/s: 1.0.0
• Component/s: Query Planning & Optimization
• Assignee: Sean Hsuan-Yi Chu
• Reporter: Abhishek Girish
• Created: 04/Mar/15 04:06
• Updated: 02/Jul/15 13:58
• Resolved: 14/May/15 18:45

Description

The following query fails to execute:

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

Log snippet attached.

The following query executes fine (although returns incomplete results - see DRILL-2376:

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;

Issue Links

• depends upon: DRILL-2207 Fix Union All Operator
• depends upon: DRILL-2376 UNION ALL on Aggregates with GROUP BY returns incomplete results
• is related to: DRILL-2376 UNION ALL on Aggregates with GROUP BY returns incomplete results