cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results forย 
Search instead forย 
Did you mean:ย 
Help
Data Engineering
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results forย 
Search instead forย 
Did you mean:ย 

What's the difference between Pig and Hive?

Kaniz
Community Manager
Community Manager

โ€Ž09-29-2021 08:31 PM

 
Labels:
0 Kudos
1 REPLY 1

Kaniz
Community Manager
Community Manager

โ€Ž09-30-2021 11:11 PM

The differences are as follows:-

  1. Pig operates on the client-side of a cluster whereas Hive operates on the server-side of a cluster.
  2. Pig uses pig-Latin language whereas Hive uses HiveQL language.
  3. Pig is a Procedural Data Flow Language whereas Hive is a Declarative SQLish Language.
  4. Pig was developed by Yahoo whereas Hive was developed by Facebook.
  5. Pig is used to handle structured and semi-structured data whereas Hive is mainly used to handle structured data.
  6. Pig does not have a dedicated metadata database whereas Hive makes use of the exact variation of dedicated SQL-DDL language by defining tables beforehand.
  7. Pig is suitable for complex and nested data structures whereas Hive is suitable for batch-processing OLAP systems.
  8. Pig does not support schema to store data whereas Hive supports schema for data insertion in tables.

0 Kudos
Announcements
Welcome to Databricks Community: Lets learn, network and celebrate together

Join our fast-growing data practitioner and expert community of 80K+ members, ready to discover, help and collaborate together while making meaningful connections. 

Click here to register and join today! 

Engage in exciting technical discussions, join a group with your peers and meet our Featured Members.