Difference between Pig and Hive ?
Hive vs Pig
| PIG | HIVE |
|---|---|
| Procedural Data Flow Language | Declarative SQLish Language |
| For Programming | For creating reports |
| Mainly used by Researchers and Programmers | Mainly used by Data Analysis |
| Operates on the client side of a cluster. | Operates on the server side of a cluster. |
| Does not have a dedicated metadata database. | Makes use of exact variation of dedicated SQL DDL language by defining tables beforehand. |
| Pig is SQL like but varies to a great extent | Directly leverages SQL and is easy to learn for database experts. |
| Directly leverages SQL and is easy to learn for database experts. | Hive does not support it. |
Learn Apache pig - Apache pig tutorial - Difference between pig and hive - Apache pig examples - Apache pig programs