[
https://issues.apache.org/jira/browse/IGNITE-27822?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18104861#comment-18104861
]
Ignite TC Bot commented on IGNITE-27822:
----------------------------------------
{panel:title=Branch: [pull/13479/head] Base: [master] : No blockers
found!|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}{panel}
{panel:title=Branch: [pull/13479/head] Base: [master] : New Tests
(12)|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}
{color:#00008b}Calcite SQL 2{color} [[tests
3|https://ci2.ignite.apache.org/viewLog.html?buildId=9282827]]
* {color:#013220}IgniteCalciteTestSuite2: test_recursive_sequence.test -
PASSED{color}
* {color:#013220}IgniteCalciteTestSuite2: test_recursive_subquery.test -
PASSED{color}
* {color:#013220}IgniteCalciteTestSuite2: test_recursive_hierarchy.test -
PASSED{color}
{color:#00008b}Calcite SQL 3{color} [[tests
9|https://ci2.ignite.apache.org/viewLog.html?buildId=9282828]]
* {color:#013220}IgniteCalciteTestSuite3:
RecursiveCteIntegrationTest.testExplainRecursiveCte - PASSED{color}
* {color:#013220}IgniteCalciteTestSuite3:
RecursiveCteIntegrationTest.testRecursionStopsWhenDeltaIsEmpty - PASSED{color}
* {color:#013220}IgniteCalciteTestSuite3:
RecursiveCteIntegrationTest.testEmployeeHierarchy - PASSED{color}
* {color:#013220}IgniteCalciteTestSuite3:
RecursiveCteIntegrationTest.testRecursiveTermWithMultipleSelfReferencesIsRejected
- PASSED{color}
* {color:#013220}IgniteCalciteTestSuite3:
RecursiveCteIntegrationTest.testRecursiveDeltaIsAccountedForMemoryQuota -
PASSED{color}
* {color:#013220}IgniteCalciteTestSuite3:
RecursiveCteIntegrationTest.testRecursiveCteWithDistinctUnionIsRejected -
PASSED{color}
* {color:#013220}IgniteCalciteTestSuite3:
RecursiveCteIntegrationTest.testStateIsIsolatedBetweenSameNamedRecursiveCtes -
PASSED{color}
* {color:#013220}IgniteCalciteTestSuite3:
RecursiveCteIntegrationTest.testRecursiveTermWithoutSelfReferenceAfterOptimization
- PASSED{color}
* {color:#013220}IgniteCalciteTestSuite3:
RecursiveCteIntegrationTest.testIndependentNonDeterministicSubtreeIsEvaluatedForEveryIteration
- PASSED{color}
{panel}
[TeamCity *--> Run :: All*
Results|https://ci2.ignite.apache.org/viewLog.html?buildId=9282861&buildTypeId=IgniteTests24Java8_RunAll]
{color:#ffffff}tcbot-analysis-comment chainBuildId=9282861
rerunBuildIds=9283015,9283017,9283019{color}
> 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: 10m
> 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)
