Map_agg function replacement

We are transitioning from using Amazon Athena and have several queries we’ll be using in Dremio. We have a query that uses the map_agg function so that we can index into the map and pull data using specific values, but we realize map_agg does not work in Dremio.

Does anyone have any suggestions on what we could use to create a map, similar to the map_agg fuction? We are querying data from Amazon Glue Data Catalog.

Thank you.

@kpmsysrcgcg Could you give an example of what you’re trying to do?