Skip to content

Instantly share code, notes, and snippets.

@kgorman

kgorman/4 killer Continuous SQL query patterns_2.sql

Created April 19, 2021 18:33
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save kgorman/86b32ec35b6d32b15d34962bde07247f to your computer and use it in GitHub Desktop.
Save kgorman/86b32ec35b6d32b15d34962bde07247f to your computer and use it in GitHub Desktop.
Download ZIP
Raw
4 killer Continuous SQL query patterns_2.sql
SELECT
userid,
SUM(amount) AS theamount,
tumble_end(timestamp, interval '1' hour) AS ending_ts
FROM mystream
GROUP BY userid, tumble(timestamp, interval '1' hour)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment