trending_hashtags.sql

rockset> SELECT 
             text AS hashtag
         FROM 
             twitter_collection:entities.hashtags AS hashtags
         WHERE 
             text IS NOT NULL 
         GROUP BY 
             text 
         ORDER BY  
             COUNT(*) DESC 
         LIMIT 5; 
+-----------------+
| hashtag         |
|-----------------|
| GRAMMYs         |
| TearItUpBTS     |
| Grammys         |
| ROSÉ            |
| music           |
+-----------------+