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)