Skip to content

Instantly share code, notes, and snippets.

@apurvam

apurvam/topk.sql

Created January 30, 2018 00:57
Show Gist options
  • Save apurvam/f870a33e7da67f649d280303d31b5401 to your computer and use it in GitHub Desktop.
Save apurvam/f870a33e7da67f649d280303d31b5401 to your computer and use it in GitHub Desktop.
Download ZIP
KSQL TopK example
Raw
topk.sql
SELECT orderzip_code, TOPK(order_total, 5) FROM orders WINDOW TUMBLING (SIZE 1 HOUR) GROUP BY order_zipcode;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment