Derrick Harris has brought together a series of benchmarks conducted by the different SQL-on-Hadoop implementors comparing their solution (Impala, Stinger/Tez, HAWQ, Shark) with
For what it’s worth, everyone is faster than Hive — that’s the whole point
of all of these SQL-on-Hadoop technologies. How they compare with each other
is harder to gauge, and a determination probably best left to individual
companies to test on their own workloads as they’re making their own buying
decisions. But for what it’s worth, here is a collection of more benchmark
tests showing the performance of various Hadoop query engines against Hive,
relational databases and, sometimes, themselves.
As Derrick Harris remarks, the only direct comparisons are between HAWQ and Impala (and this seems to be old as it mentions Impala being in beta) and the benchmark run by AMPlab (the guys behind Shark) comparing Redshift, Hive, Shark, and Impala.
The good part is that both the Hive Testbench and AMPlab benchmark are available on GitHub.
Original title and link: Everything is faster than Hive