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

Jagan angry on Avanthi Srinivas on Bhimili meeting!

Avanthi Srinivas was joined in YSRCP in January this year. Avanthi joined in YSRCP seeking to contest as Bhimili Assembly segment in 2019 General Elections.
Post a Comment
Read more

TRS and BJP Friendship - MIM is silent!

Congress is the main opposition to ruling TRS in Telangana State. TRS political movements too were against to Congress in the state. Recent developments reveal that TRS is the strong political Non-NDA alliance to the BJP. TRS proves it many times during the Parliament sessions. Party stall the proceedings in Lok Sabha in the name of Muslim Reservations. TRS agitation helps BJP to avoid No-Confidence Motion. KCR raises non-Congress and Non-BJP front and met many Congress alliance parties but not NDA's. Telngana Finance Minister was not attend in any Finance Ministers meeting against to 15th Finance meeting recommendations. TRS wants for SCS to Telangana when Congress Working Committee declared it's stand on giving SCS to Andhra Pradesh. All these developments uphold the rumors of possible alliance between BJP and TRS after 2019 General Elections. As per latest political development in New Delhi, that KCR held one hour long meeting with Prime Minister Naredra Modi on variou...
Post a Comment
Read more