[CALCITE-3109] Improvements on algebraic operators to express recursive queries (RepeatUnion & TableSpool)

• Type: Task
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 1.21.0
• Labels: pull-request-available
• Assignee: Ruben Q L
• Reporter: Ruben Q L
• Created: 04/Jun/19 11:26
• Updated: 10/Sep/19 21:36
• Resolved: 25/Jul/19 07:04

Description

After the implementation of CALCITE-2812, there are some pending details to be addressed in order to make the RepeatUnion and TableSpool more consistent.
TableSpool:

• Replace String tableName with a Table (perhaps wrapped in a RelOptTable).

RepeatUnion:

• Rename maxRep as iterationLimit. Change this field to allow all integer values, and treat all negative values as "no limit".

Issue Links

• is related to: CALCITE-2812 Add algebraic operators to allow expressing recursive queries
• links to: GitHub Pull Request #1269