Hive is a data warehouse system for Hadoop that facilitates queries like formatted structure and the analysis of large data sets stored in Hadoop.
It provides a SQL-like language called HiveQL (HQL).
Performance is better in Hive since Hive engine uses the best in-built script to reduce the execution time while enabling high output.
Hive is batch-oriented and has high latency for query execution.
Hive processor converts most of its queries into a Map Reduce job which runs on Hadoop cluster