Advertisement
Guest User

Untitled

a guest
Feb 10th, 2016
63
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.34 KB | None | 0 0
  1. create table tweets_by_hashtags(
  2. hashtag text,
  3. tweet_id text,
  4. tweet_posted_time timestamp,
  5. retweet_count int,
  6. body text,
  7. primary key(hashtag, tweet_id)
  8. )
  9.  
  10. select
  11. *
  12. from
  13. tweets_by_hashtags
  14. where
  15. hashtag = 'some_hashtag' and
  16. tweet_posted_time >= 'from_time' and
  17. tweet_posted_time < 'to_time'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement