Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-855

Allow UNNEST to have multiple arguments

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 1.8.0
    • None
    • None

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

      Attachments

        Issue Links

          is related to

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-877 Allow ROW as argument to COLLECT

          • Major - Major loss of function.
          • Closed
          relates to

          Sub-task - The sub-task of the issue PHOENIX-2203 Support UNNEST WITH ORDINALITY in Calcite-Phoenix

          • Major - Major loss of function.
          • Resolved

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-854 Implement UNNEST ... WITH ORDINALITY

          • Major - Major loss of function.
          • Closed

          Activity

            People

              julianhyde Julian Hyde
              julianhyde Julian Hyde
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: