[
https://issues.apache.org/jira/browse/IGNITE-27822?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18111486#comment-18111486
]
Vladislav Pyatkov commented on IGNITE-27822:
--------------------------------------------
Merged 6f2a343d282441dc7360960a6542d4459a297358
> Support recursive query for Calcite engine
> ------------------------------------------
>
> Key: IGNITE-27822
> URL: https://issues.apache.org/jira/browse/IGNITE-27822
> Project: Ignite
> Issue Type: Improvement
> Reporter: Vladislav Pyatkov
> Assignee: Vladislav Pyatkov
> Priority: Major
> Labels: ignite-2
> Attachments: RecursiveQueryTest.java
>
> Time Spent: 3h 40m
> Remaining Estimate: 0h
>
> h3. Motivation
> Apache Calcite can parse, validate, and produce a logical plan for recursive
> CTEs using LogicalRepeatUnion, transient tables, and table spools. However,
> Ignite Calcite currently lacks the physical relational operators, planner
> rules, and runtime execution nodes required to execute such plans.
> As a result, valid hierarchical queries using {{WITH RECURSIVE}} cannot be
> executed by the Ignite Calcite engine.
> This task adds the first complete vertical slice of recursive CTE support.
> h3. Definition of done
> * Supported {{WITH RECURSIVE ... UNION ALL}} queries execute through the
> Ignite Calcite engine.
> * Recursive state is isolated between separate CTE instances and separate
> queries.
> * Recursive delta memory is included in SQL query memory accounting.
> * Distributed source-table scans can feed coordinator-side recursion.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
