Hi team, we are trying to do aggregation on a string field, e.g select name, max(url) from table group by name. But resulting numformatting exception. Is there any other way we can get one aggregated string value from a group? Thanks

How about distinct + order by?

Yes we tried that, but the problem is one name can map to multiple url, so it would return multiple rows for each distinct name. We were hoping to get just one url from the group by name.

@Jackie we should be able to allow applicable aggr functions (max,min) on String columns?

Any update on this ?