Hi Anastasios, What you want sounds like a session window [1], maybe you can refer to the doc for more details.
[1] https://nightlies.apache.org/flink/flink-docs-master/docs/dev/datastream/operators/windows/#session-windows Best, Shammon FY On Thu, Jun 15, 2023 at 10:03 PM Anastasios Makris < anastasios.makris...@gmail.com> wrote: > Hi Flink users, > > I created a KeyedStream that tracks for each user of my website some > metrics. It's time a user produces an event the metrics are recomputed and > change. > I would like to keep the outcome of a user's session at an RDBMS, which > will be a single row. > > The first and obvious solution would be to Insert the row at the RDBMS and > then update it, it's time something new occurs. > > I would like to ask if another solution is possible. > For example, could we maybe schedule to use the RDBMS as a sink of the > state before its TTL passes by? > > Best regards, > Anastasis >