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

Police Attacked Asaduddin Owaisi - Rarest Photo

Post a Comment
Read more

Asaduddin Owaisi make mockery at Muslims!

Asaduddin Owaisi who is president of All India Majlis-e-Ittehadul Muslimeen is playing crucial hidden role in TRS Government. MIM was friendly ally to Congress once in United Andhra Pradesh. 12% Minorities turns to be vote bank to Congress in every elections. MIM was openly supported Congress to counter BJP. But people are seeing very difficult situation in Telangana state. Congress is in opposition in Telangana and BJP comes to fourth position as per 2014 results. Though TRS was not in NDA, but KCR political movements seems to be close to BJP in every aspect. At the time of No-Confidence motion TRS voted for BJP government where as MIM voted against BJP. But both MIM and TRS were in good understanding in Telangana and diversified political stand at Central. During the time of Deputy Chairman for Rajya Sabha too TRS voted in favor of NDA nominee and MIM voted for Congress nominee. Now the question among many muslim voters why Owaisi brothers go along with TRS though know KCR main...
Post a Comment
Read more