You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Khurram Faraaz (JIRA)" <ji...@apache.org> on 2015/06/24 22:44:04 UTC
[jira] [Created] (DRILL-3360) Window function defined within
another window function
Khurram Faraaz created DRILL-3360:
-------------------------------------
Summary: 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: Jinfeng Ni
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)