[jira] [Updated] (DRILL-3360) Window function defined within another window function

["Sean Hsuan-Yi Chu (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DRILL-3360?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Sean Hsuan-Yi Chu updated DRILL-3360:
-------------------------------------
    Assignee: Sean Hsuan-Yi Chu  (was: Jinfeng Ni)

> Window function defined within another window function 
> -------------------------------------------------------
>
>                 Key: DRILL-3360
>                 URL: https://issues.apache.org/jira/browse/DRILL-3360
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Query Planning & Optimization
>    Affects Versions: 1.1.0
>         Environment: CentOS 4 node cluster
>            Reporter: Khurram Faraaz
>            Assignee: Sean Hsuan-Yi Chu
>              Labels: window_function
>
> Window function defined within another window function, Postgres 9.3 does not support this, Drill supports it and we see results being returned. We should not support this kind of query.
> From Postgres 9.3
> {code}
> postgres=# select rank() over(order by row_number() over(order by col_int)) from vwOnParq_wCst;
> ERROR:  window functions are not allowed in window definitions
> LINE 1: select rank() over(order by row_number() over(order by col_i...
> {code}
> From execution on Drill
> {code}
> 0: jdbc:drill:schema=dfs.tmp> select rank() over(order by row_number() over(order by col_int)) from vwOnParq_wCst;
> +---------+
> | EXPR$0  |
> +---------+
> | 1       |
> | 2       |
> | 3       |
> | 4       |
> | 5       |
> | 6       |
> | 7       |
> | 8       |
> | 9       |
> | 10      |
> | 11      |
> | 12      |
> | 13      |
> | 14      |
> | 15      |
> | 16      |
> | 17      |
> | 18      |
> | 19      |
> | 20      |
> | 21      |
> | 22      |
> | 23      |
> | 24      |
> | 25      |
> | 26      |
> | 27      |
> | 28      |
> | 29      |
> | 30      |
> +---------+
> 30 rows selected (0.377 seconds)
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)