group_by_hop_distinct.sql 373 B

1234567891011121314151617
  1. /* Test is broken for now */
  2. /* syntax version 1 */
  3. /* postgres can not */
  4. /* ytfile can not */
  5. /* yt can not */
  6. /* dq can not */
  7. /* dqfile can not */
  8. PRAGMA dq.AnalyticsHopping="true";
  9. SELECT
  10. user,
  11. HOP_START() as ts,
  12. SUM(DISTINCT payload) as payload
  13. FROM plato.Input
  14. GROUP BY HOP(DateTime::FromSeconds(CAST(ts as Uint32)), "PT10S", "PT10S", "PT10S"), user;