Read Partha Protim Pegu's full review
Hive is a great tool for running queries on a large number of tabulated data. It is easy to use. Our team uses it mostly for running complex Join queries. But again it's the speed that is the differentiating factor. It turns out that MapReduce is not that fast when compared to other alternatives.