Ashish Khatkar
07/18/2024, 11:17 AMid : string
city : string
name: string
I want to get the output as
city : string
agg_names : array < record < string, string>> [{id, name}]
Currently, I tried using
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.