[jira] [Created] (DRILL-5421) Allow Complex type as @Workspace variables for aggregate functions

["Manuel Aristaran (JIRA)" <ji...@apache.org>]

Manuel Aristaran created DRILL-5421:
---------------------------------------

             Summary: Allow Complex type as @Workspace variables for aggregate functions
                 Key: DRILL-5421
                 URL: https://issues.apache.org/jira/browse/DRILL-5421
             Project: Apache Drill
          Issue Type: Wish
          Components: Functions - Drill
    Affects Versions: 1.10.0
            Reporter: Manuel Aristaran


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|https://drill.apache.org/docs/developing-an-aggregate-function/]:

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

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






--
This message was sent by Atlassian JIRA
(v6.3.15#6346)