[
https://issues.apache.org/jira/browse/IGNITE-29041?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18112415#comment-18112415
]
Ignite TC Bot commented on IGNITE-29041:
----------------------------------------
A documentation pull request has been opened for this issue:
https://github.com/apache/ignite/pull/13556
The PR documents Calcite recursive CTE support, including WITH RECURSIVE /
UNION ALL usage, the current limitations, memory quota behavior, and
sql.calcite.recursiveCteIterationLimit.
> [doc] Document recursive CTE support in Calcite SQL engine
> ----------------------------------------------------------
>
> Key: IGNITE-29041
> URL: https://issues.apache.org/jira/browse/IGNITE-29041
> Project: Ignite
> Issue Type: Task
> Components: documentation
> Reporter: Ignite TC Bot
> Priority: Major
> Labels: ignite-2
> Fix For: 2.19
>
> Time Spent: 10m
> Remaining Estimate: 0h
>
> Document Apache Ignite 2 Calcite SQL recursive CTE support added by
> IGNITE-27822 / PR https://github.com/apache/ignite/pull/13479.
> The docs should cover:
> * WITH RECURSIVE support in the Calcite-based SQL engine;
> * supported UNION ALL recursive CTE shape, including hierarchy traversal /
> sequence-style examples;
> * the current limitation that UNION DISTINCT is not supported yet;
> * recursive CTE execution is coordinator-side for the recursive delta and is
> accounted by Calcite query memory quotas;
> * the distributed property sql.calcite.recursiveCteIterationLimit, default
> 100, and that a negative value disables the limit.
> Suggested pages:
> * docs/_docs/SQL/sql-calcite.adoc for usage, limits, and property details;
> * docs/_docs/sql-reference/sql-conformance.adoc to remove or narrow the stale
> statement that recursive WITH fails in Ignite.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
