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

Implement UNNEST ... WITH ORDINALITY

    XMLWordPrintableJSON

Details

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

    Description

      The SQL standard provides UNNEST, a function that converts a multiset- or array-valued scalar expression into a relation. Calcite already implements this (for multisets).

      This case would add support for WITH ORDINALITY, the generated relation has an additional ORDINALITY column that contains the position of the element in the array.

      See http://farrago.sourceforge.net/design/CollectionTypes.html for examples.

      Attachments

        Issue Links

          is depended upon by

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

          • Major - Major loss of function.
          • Resolved
          is related to

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-855 Allow UNNEST to have multiple arguments

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

          Sub-task - The sub-task of the issue PHOENIX-953 Support UNNEST for ARRAY

          • Major - Major loss of function.
          • Closed

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: