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
