Fabrizzio Chavez
06/14/2025, 2:52 PMINSERT INTO player_scores_sink
SELECT
playerId,
MAX(score) AS maxScore
FROM
players_source
GROUP BY
playerId;
According to the documentation the group by will generate a stateful app, but my doubt is what is stored? only the playerId and the maxScore (two integer values) ? or the history of events that came from the players_source also will be stored?
I only want to store the playerId and the maxScore so when a new event of this player arrives I want to compare only with the previous aggregation, but not with all historical events to prevent uncontrollable storage growth