in Education by
I have just started with Hadoop. Using Cloudera's Hadoop VM, I worked with Hive, Pig and Hadoop. As I worked, I realized that PIG and HIVE are doing the same job, they have the same purpose. So, I wanna know what is the difference between them, why do we need them both? Select the correct answer from above options

1 Answer

0 votes
by
I think your question can be answered in two ways, The shorter explanation: I believe that they are/were independent projects and there was no centrally coordinated goal.They were separated in their own sense when they were first introduced but as they evolved comparison and overlap seems to have been a case. The detailed explanation: Pig’s programming language aka Pig Latin is a coding approach that provides high degree of abstraction for MapReduce programming but is a procedural in nature not declarative. Pig Latin code is extended through varied user outlined functions that are written in Python, Java, Groovy, JavaScript, and Ruby. Pig has tools for information storage, information execution and information manipulation.In Hive on the other hand, tables and databases are created first and then data is loaded into these tables. It is more structured, resembles SQL. Some of the comparison points are given below: Apache Pig may be a scripting language and Hive may be a SQL like search language. Hive requires very few lines of code when compared to Pig because of its SQL like resemblance. Pig has issues in handling unstructured information like pictures, videos, audio, text that's unequivocally delimited, log data, etc. Pig is faster in the data import but slower in actual execution to a language like Hive. Pig has no metadata support, (or it is optional, in future it may integrate hcatalog). Hive has tables' metadata stored in database. So to conclude, the purpose of both are different but under the hood, both do the same, convert to map reduce programs.

Related questions

0 votes
    What is the difference between Hadoop, HBase, Hive and Pig? I know the basic Definitions of all these terms, But ... can these be used? Select the correct answer from above options...
asked Jan 20, 2022 in Education by JackTerrance
0 votes
    Can someone tell me what is metadata? What is the difference between Internal tables and external tables in the hive? Select the correct answer from above options...
asked Jan 21, 2022 in Education by JackTerrance
0 votes
    In the hive, partitioning and bucketing a table, both are done on a column. But how exactly are they different? Select the correct answer from above options...
asked Jan 21, 2022 in Education by JackTerrance
0 votes
    Can anyone tell me why Hive is used in Hadoop? Select the correct answer from above options...
asked Jan 11, 2022 in Education by JackTerrance
0 votes
    Is there any way or any command which I can use in command prompt to know the version of Hadoop? Also, how ... the version of Hive? Select the correct answer from above options...
asked Jan 21, 2022 in Education by JackTerrance
0 votes
    I run hive query by java code. Example: "SELECT * FROM table WHERE id > 100" How to export result to hdfs file.a Select the correct answer from above options...
asked Jan 28, 2022 in Education by JackTerrance
0 votes
    I want to put my Results of a hiveql query into a CSV file. How can I do it? I tried doing this, but ... select goods from the table; Select the correct answer from above options...
asked Jan 21, 2022 in Education by JackTerrance
0 votes
    Can anyone tell me why Hive is not a database? Select the correct answer from above options...
asked Jan 11, 2022 in Education by JackTerrance
0 votes
    In Hive, when we do a query (like: select * from employee), we do not get any column names in the ... when you execute any query? Select the correct answer from above options...
asked Jan 28, 2022 in Education by JackTerrance
0 votes
    Can anyone tell me whether Hive is easy to learn? Select the correct answer from above options...
asked Jan 11, 2022 in Education by JackTerrance
0 votes
    Can Hive be used for unstructured data? Select the correct answer from above options...
asked Jan 11, 2022 in Education by JackTerrance
0 votes
    Can anyone tell me what are the advantages of Hive? Select the correct answer from above options...
asked Jan 11, 2022 in Education by JackTerrance
0 votes
    Can anyone tell whether Hive is SQL or NoSQL? Select the correct answer from above options...
asked Jan 11, 2022 in Education by JackTerrance
0 votes
    Can anyone tell me what kind of data warehouse application is suitable for Hive? Select the correct answer from above options...
asked Jan 8, 2022 in Education by JackTerrance
0 votes
    I have this set of data: dump data; This is a sample output: (this dataset is almost a million ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Apr 7, 2022 in Education by JackTerrance
...