Skip to content

Instantly share code, notes, and snippets.

@kleong

kleong/incoming_tweets.sql

Created July 30, 2019 20:28
Show Gist options
  • Save kleong/a83574e2124a1650e55d1881ed48474b to your computer and use it in GitHub Desktop.
Save kleong/a83574e2124a1650e55d1881ed48474b to your computer and use it in GitHub Desktop.
Download ZIP
Raw
incoming_tweets.sql
SELECT count(*)
FROM "twitter-kinesis-demo"
WHERE cast(timestamp_ms AS INT) > unix_millis(current_timestamp() - seconds(2));
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment