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

Allow UNNEST to have multiple arguments

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.8.0
    • Component/s: None
    • Labels:
      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).

        Issue Links

          Activity

          Hide
          julianhyde Julian Hyde added a comment -

          Resolved in release 1.8.0 (2016-06-13).

          Show
          julianhyde Julian Hyde added a comment - Resolved in release 1.8.0 (2016-06-13).
          Hide
          julianhyde Julian Hyde added a comment -

          Fixed in http://git-wip-us.apache.org/repos/asf/calcite/commit/354e8240.

          By the way, you can use UNNEST ... WITH ORDINALITY with multiple arguments too.

          Show
          julianhyde Julian Hyde added a comment - Fixed in http://git-wip-us.apache.org/repos/asf/calcite/commit/354e8240 . By the way, you can use UNNEST ... WITH ORDINALITY with multiple arguments too.

            People

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

              Dates

              • Created:
                Updated:
                Resolved:

                Development