Ignite TC Bot created IGNITE-29041:
--------------------------------------
Summary: [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
Fix For: 2.19
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)
