[
https://issues.apache.org/jira/browse/IGNITE-28895?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18096282#comment-18096282
]
Ignite TC Bot commented on IGNITE-28895:
----------------------------------------
Documentation patch prepared for review.
The draft was reworked to avoid adding more content to the already large
Calcite SQL page. The detailed window function documentation is now a separate
SQL Reference page, with the Calcite page reduced to a short pointer.
Current local commit: ad4b6f885a (IGNITE-28895 Add SQL window functions
reference).
Main docs changes:
- add docs/_docs/sql-reference/window-functions.adoc;
- add SQL Reference -> Window Functions to docs/_data/toc.yaml;
- replace the long window-functions subsection in
docs/_docs/SQL/sql-calcite.adoc with a link to the new reference page.
The content covers OVER, PARTITION BY, ORDER BY, ROWS/RANGE frames, supported
aggregate/ranking/value window functions, and examples verified against the
Ignite Calcite window-function tests.
> [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
> Assignee: Ignite TC Bot
> Priority: Major
> Labels: ise
> Time Spent: 10m
> Remaining Estimate: 0h
>
> 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)
