[
https://issues.apache.org/jira/browse/DRILL-3663?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14712195#comment-14712195
]
Sean Hsuan-Yi Chu commented on DRILL-3663:
------------------------------------------
The following is how our reproduction looks:
1. The root of the from-clause points at a directory as:
2015 -| Jan
-| Feb
-| Mar
And in each subdirectory we had an identical cdv file.
2. create view v as (select dir0 as yr, dir1 as mth, col as RecordCount from
root)
3. Then, we ran both the queries (i.e., one with order by and the other without
order by)
4. However, we did not observe the behavior.
---------------------------
Can you please confirm if the above simulates your setting? And which Drill
version did you test on?
> 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)
