[CALCITE-129] Support recursive WITH queries

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.36.0
• Labels: github-import pull-request-available
• Assignee: Hanumath Rao Maduri
• Reporter: GitHub Import
• Created: 18/Jun/14 08:14
• Updated: 05/Jan/24 00:56
• Resolved: 30/Oct/23 18:29

Description

Building on CALCITE-128, enable the RECURSIVE keyword.

This feature allows relations to be computed iteratively. Whereas CALCITE-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

Issue Links

• blocks: CALCITE-4356 In JDBC adapter, generate WITH RECURSIVE queries
• is blocked by: CALCITE-2812 Add algebraic operators to allow expressing recursive queries
• relates to: CALCITE-6188 Multi-query optimization
• requires: CALCITE-128 Support WITH queries (common table expressions)
• links to: GitHub Pull Request #3480