Scaling Hive based datawarehouse in FB

https://code.facebook.com/posts/229861827208629/scaling-the-facebook-data-warehouse-to-300-pb/

Hortonworks HDP - Hive and Pig interface

Hortonworks Hcatalog interface is pretty useful for quick ingest and query. Also check out quick start slides on how to start the sandbox vm.

http://hortonworks.com/hadoop-tutorial/hello-world-an-introduction-to-hadoop-hcatalog-hive-and-pig/#loading

Hortonworks Sandbox Startup Guide for VirtualBox from Hortonworks