[
https://issues.apache.org/jira/browse/DRILL-3663?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14908949#comment-14908949
]
Victoria Markman commented on DRILL-3663:
-----------------------------------------
Can't reproduce in 1.2.0 either:
{code}
0: jdbc:drill:schema=dfs> create or replace view v1 as select dir0 AS yr, dir1
AS mth, count(*) AS RecordCount from test where dir0 in( '2015') group by
dir0,dir1;
+-------+------------------------------------------------------+
| ok | summary |
+-------+------------------------------------------------------+
| true | View 'v1' replaced successfully in 'dfs.tmp' schema |
+-------+------------------------------------------------------+
1 row selected (0.385 seconds)
0: jdbc:drill:schema=dfs> select * from v1;
+-------+------+--------------+
| yr | mth | RecordCount |
+-------+------+--------------+
| 2015 | Q1 | 10 |
+-------+------+--------------+
1 row selected (0.429 seconds)
{code}
> 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)
