Stanilovsky Evgeny created IGNITE-14777:
-------------------------------------------

             Summary: row_number() with window functions unsupported.
                 Key: IGNITE-14777
                 URL: https://issues.apache.org/jira/browse/IGNITE-14777
             Project: Ignite
          Issue Type: Improvement
          Components: sql
            Reporter: Stanilovsky Evgeny


subclass of window queries with _row_number_ functionality are not supported 
for now.
examples:

{noformat}
SELECT i, j, row_number() OVER (PARTITION BY i ORDER BY j NULLS FIRST) FROM 
test ORDER BY i NULLS FIRST, j NULLS FIRST;
---
SELECT i, (SELECT row_number() OVER (ORDER BY i) FROM integers WHERE i1.i=i) 
FROM integers i1 ORDER BY i;
{noformat}




--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Reply via email to