# Support redshift list\_agg

**URL:** https://community.dremio.com/t/support-redshift-list-agg/1372
**Category:** Uncategorized
**Created:** [June 26, 2018, 10:56pm UTC](https://community.dremio.com/t/support-redshift-list-agg/1372 "2018-06-26T22:56:48Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![nafeger](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/nafeger/32/427_2.png) [@nafeger](https://community.dremio.com/u/nafeger)
#### Post date: [June 26, 2018, 10:56pm UTC](https://community.dremio.com/t/support-redshift-list-agg/1372/1 "2018-06-26T22:56:48Z")

</div>

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](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.

---

<div class="post-metadata">

### Author: ![rickshaw](https://avatars.discourse-cdn.com/v4/letter/r/91b2a8/32.png) [@rickshaw](https://community.dremio.com/u/rickshaw)
#### Post date: [October 25, 2018, 5:51pm UTC](https://community.dremio.com/t/support-redshift-list-agg/1372/2 "2018-10-25T17:51:42Z")

</div>

Hi,

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

Anyone?

Thanks,

Rick…

---

<div class="post-metadata">

### Author: ![jclorenzo](https://avatars.discourse-cdn.com/v4/letter/j/47e85d/32.png) [@jclorenzo](https://community.dremio.com/u/jclorenzo)
#### Post date: [November 30, 2018, 3:11pm UTC](https://community.dremio.com/t/support-redshift-list-agg/1372/3 "2018-11-30T15:11:25Z")

</div>

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

---

<div class="post-metadata">

### Author: ![firefly707](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/firefly707/32/646_2.png) [@firefly707](https://community.dremio.com/u/firefly707)
#### Post date: [November 30, 2018, 9:11pm UTC](https://community.dremio.com/t/support-redshift-list-agg/1372/4 "2018-11-30T21:11:14Z")

</div>

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

---

<div class="post-metadata">

### Author: ![sbyte](https://avatars.discourse-cdn.com/v4/letter/s/ba9def/32.png) [@sbyte](https://community.dremio.com/u/sbyte)
#### Post date: [September 14, 2020, 3:02am UTC](https://community.dremio.com/t/support-redshift-list-agg/1372/5 "2020-09-14T03:02:55Z")

</div>

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

---

<div class="post-metadata">

### Author: ![anitelleth](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/anitelleth/32/3057_2.png) [@anitelleth](https://community.dremio.com/u/anitelleth)
#### Post date: [September 17, 2020, 6:09pm UTC](https://community.dremio.com/t/support-redshift-list-agg/1372/6 "2020-09-17T18:09:49Z")

</div>

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

[https://ideas.powerbi.com/](https://ideas.powerbi.com/)