@vsr1 is there a solution for this?
I have some documents, and I would like to group them by an attribute and generate an array on another attribute
select pp, sum(pv), <an array of field “im”> from bucket group by pp
and the <an array of field “im”> should return something like [1,6,8]
Also, the values in the array should be unique (without duplicates)
Could this be done?
I think I made it work with ARRAY_AGG(DISTINCT mi)