Cloudera said the tool is primarily designed for ad-hoc SQL queries for interactive and exploratory analysis on large datasets, while Hive and MapReduce are preferable tools to use for extremely ...