You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Sean Hsuan-Yi Chu (JIRA)" <ji...@apache.org> on 2015/08/26 01:48:45 UTC
[jira] [Commented] (DRILL-3663) Drill View aliases being lost via ‘order by’
[ 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)