How do I do “array_agg” (in Presto’s sense) in Pinot? (The agg function should just return an array of all the elements.) Should I write my own custom agg function, or run it in Presto? Thanks!

sumMV?

I’m aggregating on a non-numeric column. For example:

select student, array_agg(course)
from transcript
group by 1

would produce something like:

John, [English, Math]
Mary, [Math]

Aggregation functions in Pinot are on numeric values today.