Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- create table tweets_by_hashtags(
- hashtag text,
- tweet_id text,
- tweet_posted_time timestamp,
- retweet_count int,
- body text,
- primary key(hashtag, tweet_id)
- )
- select
- *
- from
- tweets_by_hashtags
- where
- hashtag = 'some_hashtag' and
- tweet_posted_time >= 'from_time' and
- tweet_posted_time < 'to_time'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement