[IMPALA-1006] Nested union all with an order by column that is not in the outer select list fails.

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: Impala 1.3.1
• Fix Version/s: Impala 1.4
• Labels: impala
• Assignee: Srinath
• Reporter: Srinath
• Created: 20/May/14 21:46
• Updated: 20/Dec/15 00:05
• Resolved: 09/Jun/14 21:55

Description

The following query (using the functional.alltypesagg table) fails:
explain select int_col from (select int_col, bigint_col from alltypesagg union all (select int_col, bigint_col from alltypesagg) order by bigint_col limit 10) A

[localhost:21000] > explain select int_col from (select int_col, bigint_col from alltypesagg union all (select int_col, bigint_col from alltypesagg) order by bigint_col limit 10) A;
Query: explain select int_col from (select int_col, bigint_col from alltypesagg union all (select int_col, bigint_col from alltypesagg) order by bigint_col limit 10) A
ERROR: IllegalStateException: null