[DRILL-3663] Drill View aliases being lost via ‘order by’

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Cannot Reproduce
• Fix Version/s: 1.2.0
• Component/s: Query Planning & Optimization
• Assignee: Sean Hsuan-Yi Chu
• Reporter: Soumendra Kumar Mishra
• Created: 18/Aug/15 16:36
• Updated: 26/Sep/15 00:56
• Resolved: 25/Aug/15 17:39

Description

Drill view aliases being lost via ‘order by’ in select query:

-----------------------------------------------------------------------------------
Query-1: select * from factory.View.vw_factory_data_summary
-----------------------------------------------------------------------------------
yr mth RecordCount
2015 Jan 32467890
2015 Feb 44751224
2015 Mar 76564531

----------------------------------------------------------------------------------------------------
Query-2: select * from factory.View.vw_factory_data_summary order by mth
----------------------------------------------------------------------------------------------------
dir0 dir1 RecordCount
2015 Jan 32467890
2015 Feb 44751224
2015 Mar 76564531

Issue:
In Query-2, column headers are changed i.e. aliases being lost