HOWTO use Hive to SQLize your own Tweets – Part One: ETL and Schema Discovery by Russell Jurney.
HOWTO use Hive to SQLize your own Tweets – Part Two: Loading Hive, SQL Queries
Russell walks you through extracting your tweets, discovering their schema, loading them into Hive and querying the result.
I just requested my tweets on Friday so expect to see them tomorrow or Tuesday.
Will be a bit more complicated than Russell’s example because I re-post tweets about older posts on my blog.
I will have to delete those, although I may want to know when a particular tweet appeared, which means I will need to capture the date(s) when a particular tweet appeared.
BTW, if you do obtain your tweet archive, consider donating it to #Tweets4Science.