[IGNITE-14777] row_number() with window functions unsupported.

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: sql
• Labels: calcite calcite2-required calcite3-required
• Assignee: Unassigned
• Reporter: Evgeny Stanilovsky
• Created: 25/May/21 13:27
• Updated: 18/Jun/21 09:33

Description

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

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;

Issue Links

• is part of: IGNITE-12248 Apache Calcite based query execution engine