drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Victoria Markman (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-3663) Drill View aliases being lost via ‘order by’
Date Sat, 26 Sep 2015 00:57:04 GMT

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

Mime
View raw message