Skip to content

Instantly share code, notes, and snippets.

@miguno
Last active January 9, 2020 22:15
Embed
What would you like to do?
ksqlDB example: Continuously aggregating a stream into a table with a push query
-- Continuously aggregating a stream into a table with a ksqlDB push query.
CREATE STREAM locationUpdatesStream ...;
CREATE TABLE locationsPerUser AS
SELECT username, COUNT(*)
FROM locationUpdatesStream
GROUP BY username
EMIT CHANGES;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment