Is there a way to collect rows using group by with...
# troubleshooting
a
Is there a way to collect rows using group by without using udf? Given a table
Copy code
id : string
city : string
name: string
I want to get the output as
Copy code
city : string
agg_names : array < record < string, string>> [{id, name}]
Currently, I tried using
Copy code
SELECT city, COLLECT(ROW(id, name)) as agg_names FROM nameTable GROUP BY city
While writing to kafka topic, this throws error
Avro format doesn't support non-string as key type of map
as the collect returns a multiset and it maps to map avro type.