Hello, I have a question related to flink SQL and ...
# troubleshooting
f
Hello, I have a question related to flink SQL and a stream flow: I will receive an unbounded event stream from a pulsar source called player, so I want to sink to other pulsar topic with this query:
Copy code
INSERT 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