Hive

Apache Hive™ is a data warehouse software which facilitates reading, writing, and managing large datasets residing in distributed storage and queried using SQL.
At Sumanas Technologies we use Hadoop to leverage Hive’s Running HiveServer2 and Beeline. Use map-reduce queries controlled by the Hadoop configuration variables, enable log4j for logging.