Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-5421

Allow Complex type as @Workspace variables for aggregate functions

    XMLWordPrintableJSON

Details

    • Wish
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 1.10.0
    • None
    • Functions - Drill
    • None

    Description

      I'm trying to implement the equivalent of Postgres' array_agg() as a UDF in Drill. Unless I'm missing something, this doesn't seem to be possible. As per the documentation:

      Do not use complex @Workspace variables.
      You cannot allocate a Repeated* value or have a ComplexWriter in the @Workspace.

      With that restriction, it's not possible to keep the intermediate value of the resulting array during computation of the aggregation.

      Attachments

        Activity

          People

            Unassigned Unassigned
            maristaran Manuel Aristaran
            Votes:
            3 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated: