The purpose of this experiment is to load data into the Amazon Redshift cluster and perform the following queries in SQL:
- the country which has authored the most tweets
- the most frequent hashtag/word mentioned in Experiment II found in tweets from each country
- the most frequent hashtag/word mentioned in Experiment II found in all tweets
- total number of user mentions in tweets from each country respectively, and
- total number of user mentions in all tweets.
The data used here is the public tweets streamed from twitter which was uploaded in https://github.com/nishalittil/Twiiter_live_streaming.