ydb/yt/yql/tests/sql/suites/aggregate/group_by_session_nopush.sql

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

SELECT * FROM (
    SELECT
        user,
        cast(session_start as Int64) as ss,
	ListSort(AGGREGATE_LIST(ts)) as session,
        COUNT(1) as session_len
    FROM plato.Input
    GROUP BY SessionWindow(ts, 10) as session_start, user
)
WHERE ss != 100500; -- should not push down