Tuesday, May 27, 2014

Which device is famous for tweeting in Korea

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;  


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

No comments:

Post a Comment