This Tutorial showed the steps that one can carry out for fetching data from Twitter, load into Apache Hive Table and run regular HQL/SQL queries.
No download links available.