Difference between Hive and Pig?

All Questions › Category: Data Science › Difference between Hive and Pig?
0 Vote Up Vote Down
Anonymous asked 3 years ago

I need short information.

1 Answers
0 Vote Up Vote Down
Anonymous answered 3 years ago
  1. Both High-level Languages work on top of the map-reduce framework.
  2. Can coexist since both use the underlying HDFS and map-reduce.

language

  1. Pig is a procedural ; (A = load ‘mydata’; dump A)
  2. Hive is Declarative (select * from A)

Work Type

  1. Pig more suited for adhoc analysis (on-demand analysis of click stream search logs)
  2. Hive a reporting tool (e.g. weekly BI reporting)

Users

  1. Pig – Researchers, Programmers (build complex data pipelines, machine learning)
  2. Hive – Business Analysts

Integration

  1. Pig – Doesn’t have a thrift server(i.e no/limited cross-language support)
  2. Hive –  Thrift server

User’s need

  1. Pig – Better dev environments, debuggers expected
  2. Hive –  Better integration with technologies expected(e.g JDBC, ODBC)