Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-1665 Implement missing ARRAY built-in functions
  3. PHOENIX-953

Support UNNEST for ARRAY

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 4.6.0
    • None
    • None

    Description

      The UNNEST built-in function converts an array into a set of rows. This is more than a built-in function, so should be considered an advanced project.

      For an example, see the following Postgres documentation: http://www.postgresql.org/docs/8.4/static/functions-array.html
      http://www.anicehumble.com/2011/07/postgresql-unnest-function-do-many.html
      http://tech.valgog.com/2010/05/merging-and-manipulating-arrays-in.html

      So the UNNEST is a way of converting an array to a flattened "table" which can then be filtered on, ordered, grouped, etc.

      Attachments

        1. PHOENIX-953-v1.patch
          43 kB
          Dumindu Buddhika
        2. PHOENIX-953-v2.patch
          24 kB
          Dumindu Buddhika
        3. PHOENIX-953-v3.patch
          38 kB
          Dumindu Buddhika
        4. PHOENIX-953-v4.patch
          33 kB
          Wei Xue

        Issue Links

          is related to

          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

              Dumindux Dumindu Buddhika
              jamestaylor James R. Taylor
              Votes:
              0 Vote for this issue
              Watchers:
              10 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: