Skip to content

Instantly share code, notes, and snippets.

@kleong

kleong/get_hashtags.sql

Created August 13, 2019 00:27
Show Gist options
  • Save kleong/fe5184f9dbf5266523b9d9bac6f616b5 to your computer and use it in GitHub Desktop.
Save kleong/fe5184f9dbf5266523b9d9bac6f616b5 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
get_hashtags.sql
rockset> SELECT
text
FROM
twitter_collection:entities.hashtags AS hashtags
WHERE
text IS NOT NULL
LIMIT 5;
+----------------+
| text |
|----------------|
| Grammys |
| TearItUpBTS |
| BLINK |
| daSnakZ |
| SNKZ |
+----------------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment