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

["Michael Mior (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CALCITE-129?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16690743#comment-16690743 ] 

Michael Mior commented on CALCITE-129:
--------------------------------------

Postgres only allows queries of the form "non-recursive-term UNION [ALL] recursive-term" and uses a recursive union operator to implement the query. Seems like a similar approach could work for Calcite.

> 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
(v7.6.3#76005)