Difference between Pig, Hive and MapReduce
| Pig | Hive | Hadoop mapreduce |
|---|---|---|
| Pig is a scripting language | SQL like query language | It is a compiled language |
| Higher level of abstraction | Higher level of abstraction | Hadoop mapreduce used lower level of abstraction |
| Comparatively less line of codes than mapreduce |
Comparatively less lines of code than mapreduce and apache pig |
More lines of code |
| Development effort is less code efficiency is relatively less |
Development effort is less code efficiency is relatively less |
More development , effort is involved |
| Code efficiency is relatively less | Code efficiency is relatively less | Code efficiency is high when compared to pig and hive |
| Pig is open source | Hive open source | Hadoop MapReduce were built so that hadoop developers could do the same thing in Java in a less verbose way by writing only fewer lines of code that is easy to understand |
| Disadvantage of pig is that commands are not executed unless either you dump or store an intermediate or final result.This increases the iteration between debug and resolving the issue. |
Disadvantages of hive is that No real time access to data, Updating data is complicated |
The only drawback that developers need to write several lines of basic java code |
