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