Hello, is there any flink's built in function in sql which can combine the different group by data into 1 row?
ex:
select restaurantId as RID from (select restaurantId, sum(score) as aggregatedScore from my_stream_table group by restaurantId, HOP(proctime, INTERVAL '2' HOUR, INTERVAL '2' HOUR)) where aggregatedScore > 100;
I want to concatenate all the restaurant ids across the rows into 1 row.