window_session.sql 217 B

1234
  1. insert into plato.Output
  2. select key, row_number() over w as r, session_start() over w as s from plato.Input
  3. window w AS (PARTITION BY key, SessionWindow(cast(subkey as Datetime), DateTime::IntervalFromMinutes(15)));