group_by_hop_only.sql 280 B

123456789101112
  1. /* syntax version 1 */
  2. /* postgres can not */
  3. /* ytfile can not */
  4. /* yt can not */
  5. PRAGMA dq.AnalyticsHopping="true";
  6. SELECT
  7. HOP_START() as ts,
  8. SUM(payload) as payload
  9. FROM plato.Input
  10. GROUP BY HOP(DateTime::FromSeconds(CAST(ts as Uint32)), "PT10S", "PT10S", "PT10S");