You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Ignite TC Bot (Jira)" <ji...@apache.org> on 2026/07/14 17:52:00 UTC

[jira] [Commented] (IGNITE-28895) [doc] Document Calcite SQL window functions

    [ https://issues.apache.org/jira/browse/IGNITE-28895?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18096270#comment-18096270 ] 

Ignite TC Bot commented on IGNITE-28895:
----------------------------------------

I prepared the minimal documentation patch locally against docs/_docs/SQL/sql-calcite.adoc on branch IGNITE-28895-docs.

The local patch documents Calcite SQL window functions in the Supported Functions section: OVER, PARTITION BY, ORDER BY, ROWS/RANGE frames, aggregate window functions, ROW_NUMBER, RANK, DENSE_RANK, PERCENT_RANK, CUME_DIST, LAG, LEAD, and FIRST_VALUE.

Public PR creation is blocked in this run: git push to the configured fork ignitetcbot/ignite returned HTTP 403, and the GitHub integration cannot create a branch in apache/ignite (Resource not accessible by integration). Keeping this documentation issue open until a maintainer or an account with push permission publishes the patch.

> [doc] Document Calcite SQL window functions
> -------------------------------------------
>
>                 Key: IGNITE-28895
>                 URL: https://issues.apache.org/jira/browse/IGNITE-28895
>             Project: Ignite
>          Issue Type: Task
>          Components: documentation
>            Reporter: Ignite TC Bot
>            Priority: Major
>
> IGNITE-14777 adds user-facing support for SQL window functions in the Calcite-based SQL engine.
> Implementation evidence:
> * Source issue: https://issues.apache.org/jira/browse/IGNITE-14777
> * Implementation PR: https://github.com/apache/ignite/pull/12096
> * Merge commit: 4972dfa703aaa5e9a500ded8e6662c91f65582f3
> The implementation adds WindowNode/window execution support and tests for OVER clauses, PARTITION BY, ORDER BY, ROWS/RANGE frames, ROW_NUMBER, RANK, DENSE_RANK, PERCENT_RANK, CUME_DIST, LAG, LEAD, FIRST_VALUE, and aggregate functions used with OVER.
> Documentation should update docs/_docs/SQL/sql-calcite.adoc in the Supported Functions section with a concise description of supported window functions and syntax examples.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)