[
https://issues.apache.org/jira/browse/DRILL-3663?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14712491#comment-14712491
]
Soumendra Kumar Mishra commented on DRILL-3663:
-----------------------------------------------
1. The query used in view:
select dir0 AS yr, dir1 AS mth, count(*) AS RecordCount from factory.Data.*
group by dir0,dir1
2. Drill Version : 1.0
> 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)
