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.