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

Rare Collection : Bhuma Nagi Reddy with Sr. NTR

Please check the photo. It was in 1994 after TDP regains power in AP. Bhuma Nagi Reddy and SV Subba Reddy (father of Shobha Nagi Reddy) were met NTR along with their families. Bhuma Nagi Reddy was elected first time to Assembly as TDP candidate from Allagadda in 1992 bye-election. Again he was elected as MLA from same constituency in 1994 as TDP candidate. In 1991, late NTR decided not to field TDP nominee opposite first Telugu Prime Minister PV Narasimha Rao. In 1996, Chandra Babu Naidu (NTR was died) was selected Bhuma against them Prime Minister PV in Nandhyala. In 1991, PV majority was more than 5 lakhs but in 1996 his massive majority comes down below one lakh. It can only possible to Bhuma. PV retained Barampur in Orissa and resigned for Nandhyala. TDP was selected Bhuma as it's candidate in 1996 bye-election and Bhuma won over 4lakh majority against Gangula. Bhuma was elected again in 1998 and in 1999 bye-elections from Nandhyala. All the three times he defeated Ga...
Post a Comment
Read more

Girl signed on 100/- Stamp Paper for getting 5K!

YSRCP Govt gave notification for more than 2.6 lakh jobs for Village Volunteers and was selected through interview process. All unemployed youth from SSC to Graduate were applied for the posts. 
Post a Comment
Read more