drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Soumendra Kumar Mishra (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-3663) Drill View aliases being lost via ‘order by’
Date Wed, 26 Aug 2015 04:37:45 GMT

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

Mime
View raw message