Uploaded image for project: 'Apache MADlib'
  1. Apache MADlib
  2. MADLIB-1361

Pivot: Fix array_agg + distinct scaling issue on gpdb

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • v1.16
    • Module: Utilities
    • None

    Description

      With large datasets, pivot fails because of the array_agg(distinct) query. This is because array_agg collects the values first and filters the distinct values later. This causes the array_agg to go out of memory.

      Attachments

        Activity

          People

            Unassigned Unassigned
            okislal Orhan Kislal
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: