Vladislav Pyatkov created IGNITE-27822:
------------------------------------------
Summary: 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
h3. Motivation
SQL using "WITH RECURSIVE" is an ANSI standard. Without this type of query, it
is impossible to build a tree in the hierarchy table.
There is a simple example:
{noformat}
WITH RECURSIVE t(n) AS (SELECT 1 UNION ALL SELECT n + 1 FROM t WHERE n < 100)
SELECT sum(n) FROM t;
{noformat}
It currently returns an error.
h3. Definition of done
The query above shuld return 5050
Recursive query support
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
