blob: fd8e46a0710af37e0433d82de27f62218cefce1d (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
|
/* 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
|
