Skip to content

Instantly share code, notes, and snippets.

@apurvam

apurvam/topkdistinct.sql

Last active January 31, 2018 02:06
Show Gist options
  • Save apurvam/a7ea8cc44c04cdc2d898f96df2bafaa2 to your computer and use it in GitHub Desktop.
Save apurvam/a7ea8cc44c04cdc2d898f96df2bafaa2 to your computer and use it in GitHub Desktop.
Download ZIP
KSQL TOPKDISTINCT example
Raw
topkdistinct.sql
SELECT pageid, TOPKDISTINCT(viewtime, 5) FROM pageviews_users GROUP BY pageid;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment