[ https://issues.apache.org/jira/browse/DRILL-4933?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15551303#comment-15551303 ]
Deepak Shivamurthy edited comment on DRILL-4933 at 10/6/16 8:20 AM: -------------------------------------------------------------------- Thanks Khurram Faraaz Could you please send across URL to download stable drill 1.9.0 as I could not see in the below url; http://apache.mirrors.hoobly.com/drill/ was (Author: deepaks): Could you please send across URL to download stable drill 1.9.0 as I could not see in the below url; http://apache.mirrors.hoobly.com/drill/ > Column aliasing isn’t working when we use partition by clause with > row_number() [Ranking Window Functions] > ---------------------------------------------------------------------------------------------------------- > > Key: DRILL-4933 > URL: https://issues.apache.org/jira/browse/DRILL-4933 > Project: Apache Drill > Issue Type: Bug > Components: Functions - Drill > Affects Versions: 1.8.0 > Reporter: Deepak Shivamurthy > Priority: Minor > > I have run below query and alias is done on the third column, but still alias > does not working. > select ID, sts_utc, row_number() over(partition by ID order by sts_utc) as > `rownum` from dfs.`/tmp/events` limit 10; > Output: > ID sts_utc, $2 > I would be expecting column rownum instead of $2.. (even i have other column > names, still aliasing didnt work) -- This message was sent by Atlassian JIRA (v6.3.4#6332)