[
https://issues.apache.org/jira/browse/IGNITE-29041?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Dmitry Pavlov reassigned IGNITE-29041:
--------------------------------------
Assignee: Ignite TC Bot
> [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
> Assignee: 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)
