drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Deepak Shivamurthy (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-4933) Column aliasing isn’t working when we use partition by clause with row_number() [Ranking Window Functions]
Date Thu, 06 Oct 2016 08:20:20 GMT

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

Mime
View raw message