yql/essentials/tests/sql/suites/window/current/session_aliases.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21

/* syntax version 1 */
/* postgres can not */

SELECT
    user,
    ts,
    SessionStart() over w1 as ss1,
    SessionStart() over w as ss,
    
    AGGREGATE_LIST(ts) over w as ts_session,
    COUNT(1) over w as session_len,
FROM plato.Input
WINDOW w AS (
    PARTITION BY user, SessionWindow(ts, 10) as ss0
    ORDER BY ts
),
w1 AS (
    PARTITION BY SessionWindow(ts, 10), user
    ORDER BY ts
)
ORDER BY user, ts, session_len;