Finally we have Hive. Hive is a layer to operate on top of Hadoop. It's meant to provide a SQL like interface across data in Hadoop.