[
https://issues.apache.org/jira/browse/IGNITE-14777?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Aleksey Plekhanov updated IGNITE-14777:
---------------------------------------
Description:
Window functions 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}
was:
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}
> Calcite engine. Implement window functions
> ------------------------------------------
>
> Key: IGNITE-14777
> URL: https://issues.apache.org/jira/browse/IGNITE-14777
> Project: Ignite
> Issue Type: Improvement
> Components: sql
> Reporter: Evgeny Stanilovsky
> Priority: Major
> Labels: calcite, calcite2-required, calcite3-required
> Time Spent: 0.5h
> Remaining Estimate: 0h
>
> Window functions 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.20.10#820010)
