I was wondering how many people use android to tweet and how many use iphone, so I did little bit a research on this,
Fortunately, there is a "source" field in raw json tweet data, so I grouped tweets by that field for random day.
hive> select source, count(*) as cnt from twitter where datehour>=2014052000 and datehour<=2014052023 group by source order by cnt desc;
Result:
Note that the tweets are for May 20 including only the ones with korean syllables
Fortunately, there is a "source" field in raw json tweet data, so I grouped tweets by that field for random day.
hive> select source, count(*) as cnt from twitter where datehour>=2014052000 and datehour<=2014052023 group by source order by cnt desc;
Result:
Android | 593671 |
Web | 204334 |
Twittbot.net | 153035 |
iPhone | 144256 |
Tweetdeck | 65767 |
iPad | 19933 |
Note that the tweets are for May 20 including only the ones with korean syllables
Comments
Post a Comment