Pig and hive

--Although MapReduce is very powerful, it can also be complex to master
--Many organizations have business or data analysts who are skilled at writing SQL queries, but not at writing Java code
--Many organizations have programmers who are skilled at writing code in scripting languages
--Hive and Pig are two projects which evolved separately to help such people analyze huge amounts of data via MapReduce
  -- Hive was initially developed at Facebook, Pig at Yahoo!

Hive vs Pig
Hive
Language- HiveQL(SQL Like)
Schema -Table definition that are stored in a metastore
Programmatic access-JDBC,ODBC

Pig
Language- Pig Latin,dataflow language
Schema -a schema is optinally defined at runtime. Metastore coming soon
Programmatic access-PigServer(JAVA API)

Related Posts