[
https://issues.apache.org/jira/browse/DRILL-3663?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sean Hsuan-Yi Chu resolved DRILL-3663.
--------------------------------------
Resolution: Cannot Reproduce
This is not reproducible.
If you could offer the details (e.g., data set, query to create the view) and
you still observe this issue, please reopen this issue again.
> Drill View aliases being lost via ‘order by’
> --------------------------------------------
>
> Key: DRILL-3663
> URL: https://issues.apache.org/jira/browse/DRILL-3663
> Project: Apache Drill
> Issue Type: Bug
> Components: Query Planning & Optimization
> Reporter: Soumendra Kumar Mishra
> Assignee: Sean Hsuan-Yi Chu
> Fix For: 1.2.0
>
>
> 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
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
