Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Threaded View
Pig >> mail # user >> Re: JOIN comparasion  PIG V/S HIVE


Copy link to this message
-
Re: JOIN comparasion  PIG V/S HIVE
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
>
>
>
>
>
>    
>
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB