drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sean Hsuan-Yi Chu (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-3663) Drill View aliases being lost via ‘order by’
Date Tue, 25 Aug 2015 23:48:45 GMT

    [ 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)

Mime
View raw message