Hive provides a SQL like interface to interact with data stored in Hadoop eco-system. We can create tables in Hive and store data into them.
Hive is also used for mapping and working with HBase tables.
Under the hood, Hive queries are converted into MapReduce jobs. So Hive hides the complexity associated with creating and running of MapReduce jobs.