[ https://issues.apache.org/jira/browse/DRILL-3360?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Victoria Markman closed DRILL-3360. ----------------------------------- > 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 > Fix For: 1.2.0 > > > 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)