SQL-on-Hadoop: What does "100 times faster than Hive" actually mean?
As is the natural human wont, advocates of particular SQL-on-Hadoop solutions tend to emphasize favorable performance results derived from advantageous test settings, failing to explain the whole picture, including results across the full set of ordinary queries.
Source: www.gruter.com