Skip to content
Related Articles

Related Articles

Improve Article

Difference Between Hadoop and Hive

  • Last Updated : 06 May, 2020

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.

Hadoop-vs-Hive

Below is a table of differences between Hadoop and Hive:

HadoopHive
Hadoop is a framework to process/query the Big dataHive 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 HadoopHive’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 programHive can query the same data using 8 to 10 lines of HQL.
My Personal Notes arrow_drop_up
Recommended Articles
Page :