drill-dev 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] [Resolved] (DRILL-3663) Drill View aliases being lost via ‘order by’
Date Tue, 25 Aug 2015 17:39:46 GMT

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

Mime
View raw message