You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Hanumath Rao Maduri (Jira)" <ji...@apache.org> on 2023/10/09 18:29:00 UTC

[jira] [Commented] (CALCITE-129) Support recursive WITH queries

    [ 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)