Treasuredata put together a post comparing Presto and Hive.
Check out this Big Data benchmark comparing Redshift, Hive, Impala, Shark, Stinger/Tez
Cassandra, Hive, and Hadoop: How We Picked Our Analytics Stack zite.to/YI2xeu
The Stinger Initiative: Making Apache Hive 100 Times Faster zite.to/ZgELZ9
Here is a recent Hadoop and Hive presentation from Joydeep Sen Sarma from Facebook delivered at IIT Delhi.