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


1
2
3
4
5
6
7
8
9
10

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

PRAGMA dq.AnalyticsHopping="true";

SELECT *
FROM plato.Input
GROUP BY HOP(DateTime::FromSeconds(CAST(ts as Uint32)), "PT10S", "PT10S", "PT10S"), user;