Skip to content

Instantly share code, notes, and snippets.

@kgorman

kgorman/sample4.sql

Last active October 25, 2019 16:26
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/a33342607ae152c6a04c9d97b124aa4a to your computer and use it in GitHub Desktop.
Save kgorman/a33342607ae152c6a04c9d97b124aa4a to your computer and use it in GitHub Desktop.
Download ZIP
sample4.sql
Raw
sample4.sql
-- return aggregation of total payments
-- over a 1 hour tumbling window
SELECT SUM(CAST(amount AS numeric)) AS payment_volume,
CAST(TUMBLE_END(eventTimestamp, interval '1' hour) AS varchar) AS ts
FROM payments
GROUP BY TUMBLE(eventTimestamp, interval '1' hour);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment