[jira] [Created] (DRILL-4933) Column aliasing isn’t working when we use partition by clause with row_number() [Ranking Window Functions]

["Deepak Shivamurthy (JIRA)" <ji...@apache.org>]

Deepak Shivamurthy created DRILL-4933:
-----------------------------------------

             Summary: 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)