aboutsummaryrefslogtreecommitdiffstats
path: root/yql/essentials/tests/sql/suites/aggregate/hopping.sql
blob: a83b42124292cf53ef5679f4b6ccb650a91981e8 (plain) (blame)
1
2
3
4
5
6
7
8
9
$p = SELECT
    user,
    HOP_START() as ts,
    SUM(payload) as payload
FROM (select 'foo' as user, cast(1 as Timestamp) as ts, 10 as payload)
GROUP BY HOP(ts, "PT10S", "PT10S", "PT10S"), user;

$p = PROCESS $p;
SELECT FormatType(TypeOf($p)); -- no MultiHoppingCore comp node