Hi Sonu,

I understand you read the dezyre blog, I still recommend you to check this page(check the last passage):

/article/difference-between-pig-and-hive-the-two-key-components-of-hadoop-ecosystem/79

You can find all the necessary information you are looking for.

Hope this helps. Let me know if you are able to find the answers that you are looking for.

Thanks.

Thanks Abhijit,

I gone through the link.But still not clear the point - 

Pig is generally used by researchers and programmers while hive is mainly used for creating reports and data analysis.

How hive is used for creating reports and data analysis ? can we not used pig for that ? please explain

I have also used hive in java jdbc programming so how pig is only used for programmers ?

Hi Sonu,

>> Pig is generally used by researchers and programmers while hive is mainly used for creating reports and data analysis.
>> How hive is used for creating reports and data analysis ? can we not used pig for that ? please explain.
>>  I have also used hive in java jdbc programming so how pig is only used for programmers ?

- 2) Hive Hadoop Component is used for completely structured Data whereas Pig Hadoop Component is used for semi structured data. Data collected by researchers are typically unstructured or semi-structured but for analytics you have in structure format.

13) Pig Hadoop Component renders users with sample data for each scenario and each step through its “Illustrate” function whereas this feature is not incorporated with the Hive Hadoop Component. "Illustrate" is like preview or debug of code output. Very useful in terms of programmers or researchers while testing data.

Yes, Pig and Hive can embed in Java code. I would say Pig is mainly preferred by Programmers. 'Only' is wrong word to describe for Pig and Hive. Because Hive can be used.

To understand it more deep, please check tutorials on Pig and Hive and their architecture. You can also join any upcoming batch on Hadoop.

Hope this helps.

Thanks