Skip to content

Instantly share code, notes, and snippets.

@ldenson11 ldenson11/HyperJoin.sql Secret
Created Oct 25, 2019

Embed
What would you like to do?
-- join multiple streams
select o.name,
sum(d.clicks),
hop_end(r.eventTimestamp, interval '20' second, interval '40' second)
from click_stream o join orgs r on o.org_id = r.org_id
join models d on d.org_id = r.org_id
group by o.name,
hop(r.eventTimestamp, interval '20' second, interval '40' second)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.