drill-dev mailing list archives

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

             Summary: 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
            Reporter: Soumendra Kumar Mishra


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