Skip to main content

PIG Vs HIVE

Apache PIG and Apache HIVE are two components in HADOOP ecosystem. Both PIG and HIVE used for the developers aimed for easing in writing Java code for Mapreduce programs. Those who have not much knowledge on JAVA would opt their choice either PIG or HIVE. If we observe diagrammatic HADOOP ecosystem both PIG and HIVE have exist in same verticals. When we discussed on performance of job, both HIVE and PIG are slow compared to traditional Map Reduce job. HIVE or PIG scripts have to be converted into a series of Map Reduce jobs. But both Hive and PIG can join, order & sort dynamically.
PIGHIVE
It is best for semi structured dataIt is best for structured Data
It is developed for programmingIt is meant for reporting
It is used as procedural languageIt is used as a declarative SQL
It does not support PARTITIONSHive supports PARTITIONS
PIG can't start thrift based serverHive can start an optional thrift based server
PIG don't have dedicated metadata of databaseIt defines tables before hand (schema) + stores schema information in database
PIG supports Avro file formatHive does not support Avro
It supports additional COGROUP feature for performing outer joinsIt doesn't support COGROUP
Labels:

Comments

Post a Comment

Popular posts from this blog

Photo : Savitri during her last days

Even after 4 decades of her death, people are very much interested to watched her (Savitri) biopic. Mahanati turned to be stupendous success. On eve of remembering Savitri, here we posted Savitri photo. The photo seems her last days. The man stand behind Savitri is Gemini Ganeshan who married Savitri. It seems that she suffered bad days during her last days.
Post a Comment
Read more

PK Fans - Political and Private life

Pawan Kalyan fans attack Director Ram Gopal Varma's office for making parody film "Power Star" on their hero. RGV made a complaint and withdraw later for unknown reasons. 
Post a Comment
Read more

Who killed cricket in Pakistan?

Pakistan won the 1992 WC under the leadership of one of the greatest all-rounders in the world Imran Khan. Now, he is leading the country as Prime Minister of Pakistan. Every cricket lover in the country wants to see the glory in the gentleman game after Imran became PM for Pakistan. But his leadership can’t give any assurance to other nations to play the game in Pakistan. New Zealand abandoned the historic Pakistan tour just a few minutes after the first ball was to be bowled in the first ODI in Rawalpindi. Both teams have considered this series as preparation for the ICC T20 World Cup. Kiwis cites ‘Security threat’ to its players in Pakistan. There is a question that arises why NZ came and cancelled the visit. This is a massive blow to Pakistan cricket who wants to revive the game in the country. Prime Minister Imran Khan had spoken to New Zealand Prime Minister Jacinda Ardern and informed her about the security arrangements. Pakistan Cricket Board (PCB) fumes over Black Caps decisio...
Post a Comment
Read more