Over the last week I've created hive tables for many of our larger datasets in Hadoop. Those were used to generate many of the results you've seen in the last few days.Both the schemas for those tables and the job-scripts can be found in:
_______________________________________________
Analytics mailing list
Analytics@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/analytics