Support redshift list_agg

1

Would be great if there was a way to support list_agg from redshift. For example:

listagg(u.first_name || ’ ’ || u.last_name, ', ')
within GROUP (ORDER BY u.last_name ASC, u.first_name ASC, u.id ASC)

https://docs.aws.amazon.com/redshift/latest/dg/r_LISTAGG.html

Perhaps this could be externalized as a secret function that gets passed directly to the datastore. So:

{hardcoded_function: listagg... returns varchar(256) } this way the query parser wouldn’t have to support every goofball feature of everything everywhere.

This might give us group_concat as well.

2 Likes
2

Hi,

Any luck with List_agg? I am also looking for such function similar to Oracle’s Listagg.

Anyone?

Thanks,

Rick…

3

Hey Rick,
Did you guys ever workout a workaround the ListAgg function ? Thanks.

4

Hi folks. I’m not aware of any workarounds, but this is something we can look into as an enhancement in a later release.

5

I am looking for this feature, was there any enhancements put in since then?

6

we could have a portal here to upvote desired features, as we have it for Power BI:

https://ideas.powerbi.com/