[CALCITE-855] Allow UNNEST to have multiple arguments

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.8.0
• Assignee: Julian Hyde
• Reporter: Julian Hyde
• Created: 27/Aug/15 22:27
• Updated: 08/Aug/24 23:49
• Resolved: 06/May/16 07:04

Description

The SQL standard allows UNNEST to have more than one argument. The result is a collection of records whose i'th record draws fields from the i'th record of each input.

We have laid groundwork for this in CALCITE-854, specifically how the type of an Uncollect is derived. Uncollect will continue to have one input, but with this change, the input may now have more than one column. Each column must be an array or multiset (slightly looser than the standard, which only allows multiple arguments if all are arrays).

Issue Links

• is related to: CALCITE-6521 CROSS JOIN UNNEST The results do not match expectations.
• is related to: CALCITE-877 Allow ROW as argument to COLLECT
• relates to: PHOENIX-2203 Support UNNEST WITH ORDINALITY in Calcite-Phoenix
• relates to: CALCITE-854 Implement UNNEST ... WITH ORDINALITY