Difference Between Hadoop and Hive

Hadoop: Hadoop is a Framework or Software which was invented to manage huge data or Big Data. Hadoop is used for storing and processing large data distributed across a cluster of commodity servers. Hadoop stores the data using Hadoop distributed file system and process/query it using the Map-Reduce programming model.

Hive: Hive is an application that runs over the Hadoop framework and provides SQL like interface for processing/query the data. Hive is designed and developed by Facebook before becoming part of the Apache-Hadoop project. Hive runs its query using HQL (Hive query language). Hive is having the same structure as RDBMS and almost the same commands can be used in Hive. Hive can store the data in external tables so it’s not mandatory to used HDFS also it support file formats such as ORC, Avro files, Sequence File and Text files, etc.


Below is a table of differences between Hadoop and Hive:

Hadoop Hive
Hadoop is a framework to process/query the Big data Hive is an SQL Based tool that builds over Hadoop to process the data.
Hadoop can understand Map Reduce only. Hive process/query all the data using HQL (Hive Query Language) it’s SQL-Like Language
Map Reduce is an integral part of Hadoop Hive’s query first get converted into Map Reduce than processed by Hadoop to query the data.
Hadoop understands SQL using Java-based Map Reduce only. Hive works on SQL Like query
In Hadoop, have to write complex Map Reduce programs using Java which is not similar to traditional Java. In Hive, earlier used traditional “Relational Database’s” commands can also be used to query the big data
Hadoop is meant for all types of data whether it is Structured, Unstructured or Semi-Structured. Hive can only process/query the structured data
In the simple Hadoop ecosystem, the need to write complex Java programs for the same data. Using Hive, one can process/query the data without complex programming
One side Hadoop frameworks need 100s line for preparing Java-based MR program Hive can query the same data using 8 to 10 lines of HQL.
My Personal Notes arrow_drop_up

Check out this Author's contributed articles.

If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to contribute@geeksforgeeks.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.

Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.