[
https://issues.apache.org/jira/browse/CALCITE-129?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17773446#comment-17773446
]
Hanumath Rao Maduri commented on CALCITE-129:
---------------------------------------------
[Stamatis Zampetakis|http://jira/secure/ViewProfile.jspa?name=zabetak] Can I
assign this Jira to myself, assuming no one is already looking at it. I started
looking at this support as part of enhancing our SQL engine (which uses CALCITE
for parsing and planning).
The basic approach I am planning to take for this work is
* Build upon the earlier work done as part of CALCITE-2812. I see that the
algebraic support is already done with the aforementioned JIRA (but tagged as
Experimental).
* The grammar mentioned in the
[docs|[https://calcite.apache.org/docs/algebra.html#recursive-queries]] seems
relevant with the general syntax followed by other databases (like POSTGRES). I
am assuming that this is the agreed syntax by the community( Please let me know
if it's not the case).
* I am planning to use the RECURSIVE keyword as necessary instead of optional
for any recursive query. My experimentation with postgres (9.6) also has a
similar expectation.
> Support recursive WITH queries
> ------------------------------
>
> Key: CALCITE-129
> URL: https://issues.apache.org/jira/browse/CALCITE-129
> Project: Calcite
> Issue Type: Improvement
> Reporter: GitHub Import
> Priority: Major
> Labels: github-import
>
> Building on https://github.com/julianhyde/optiq/issues/128, enable the
> RECURSIVE keyword.
> This feature allows relations to be computed iteratively. Whereas
> ([#128|https://github.com/JulianHyde/optiq/issues/128] |
> [FLINK-128|https://issues.apache.org/jira/browse/OPTIQ-128]) was mainly a
> parser/validator change, this feature requires significant changes to the
> planner and runtime.
> ---------------- Imported from GitHub ----------------
> Url: https://github.com/julianhyde/optiq/issues/129
> Created by: [julianhyde|https://github.com/julianhyde]
> Labels: enhancement,
> Created at: Tue Feb 11 20:29:35 CET 2014
> State: open
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
