[
https://issues.apache.org/jira/browse/DRILL-4933?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15823845#comment-15823845
]
[email protected] commented on DRILL-4933:
-----------------------------------------------------
I just downloaded drill 1.9.0, but still this issue exist.
> 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)
