[
https://issues.apache.org/jira/browse/DRILL-4933?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15551303#comment-15551303
]
Deepak Shivamurthy commented on DRILL-4933:
-------------------------------------------
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)
