Found a way to do this. Not sure when this functionality was released, with which version of dremio, but now you can use LIST_AGG Dremio, tested a couple of examples and it works like a charm.
Found a way to do this. Not sure when this functionality was released, with which version of dremio, but now you can use LIST_AGG Dremio, tested a couple of examples and it works like a charm.