JOIN comparasion PIG V/S HIVE

[yogesh dhari <yo...@live.com>]

Hi All,

Is it true that Pig's JOIN operation is not so efficient as of HIVE.

I have just tried over and found differences over JOIN query.

Hive resulted the same as My Sql but Pig resulted some counts lesser then Hive Join.

Please put some light over JOINS in Pig and Hive.


Regards
Yogesh Kumar Dhari





 		 	   		  

Re: JOIN comparasion PIG V/S HIVE

[Dmitriy Ryaboy <dv...@gmail.com>]

Could you provide sample data and script that would allow us to reproduce this?
Hive is faster at some things. Pig is faster at others. Both produce
correct results.

D

On Mon, Oct 22, 2012 at 11:22 AM, yogesh dhari <yo...@live.com> wrote:
>
> Hi All,
>
> Is it true that Pig's JOIN operation is not so efficient as of HIVE.
>
> I have just tried over and found differences over JOIN query.
>
> Hive resulted the same as My Sql but Pig resulted some counts lesser then Hive Join.
>
> Please put some light over JOINS in Pig and Hive.
>
>
> Regards
> Yogesh Kumar Dhari
>
>
>
>
>
>

Re: JOIN comparasion PIG V/S HIVE

[Thejas Nair <th...@hortonworks.com>]

Pig also runs its end-to-end tests against benchmark generated from 
mysql. Have you looked what rows are causing the difference ? Are you 
doing joins on floating point numbers ?

Are you using the default join or any of the specialized joins in pig ?

Thanks,
Thejas



On 10/22/12 11:22 AM, yogesh dhari wrote:
>
> Hi All,
>
> Is it true that Pig's JOIN operation is not so efficient as of HIVE.
>
> I have just tried over and found differences over JOIN query.
>
> Hive resulted the same as My Sql but Pig resulted some counts lesser then Hive Join.
>
> Please put some light over JOINS in Pig and Hive.
>
>
> Regards
> Yogesh Kumar Dhari
>
>
>
>
>
>   		 	   		
>