Actually, their goal is the same: to analysis large volume of data based on
hadoop.  They both support UDF to extend its functionality. hive also
support plug-in map-reduce script.

I think the biggest difference is their script languages: pig use pig-latin
(maybe support sql in future) while hive use sql.

To me, I prefer the pig-latin, it's more intuitive especially when script is
a little long.

2009/9/8 刘祥龙 <>

> Hi, everyone. I am trying to use pig, but now I am confused about what the
> difference is between Pig and Hive, which is more powerful or more
> convenient for users. In addition,  what is their difference from SQL.
>  Could someone help me about these questions or give me some advices?  I
> will be very appreciated.
> Thanks, everyone!
> Best Wishes!
> _____________________________________________________________
> Liu Xianglong

Reply via email to