Both are very useful for anyone who is not well versed with Java. By using these, we can easily create Map Reduce jobs without worrying about the complexities of Map Reducer tasks internal structure. But these are some differences between these two.
|Apache Pig||Apache Hive|
|Pig was developed by Yahoo||Hive was developed by Facebook|
|It uses a language called Pig Latin||It uses a query language HiveQL|
|Pig Latin is a procedural language and the syntax is similar to SQL||HiveQL is a declarative language|
|It can handle structured, unstructured, and semi-structured data||It can handle structured data alone|