Apache Pig vs Apache Hive

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