yql/essentials/tests/sql/suites/aggregate/group_by_session_only.sql


1
2
3
4
5
6
7
8

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

SELECT
    MIN(ts) ?? 100500 as session_start,
FROM plato.Input
GROUP BY SessionWindow(ts, 9)
ORDER BY session_start