Re: Question on bucketed map join

2012-03-26 Thread Amit Sharma
19, 2012 9:23 PM *Subject:* Question on bucketed map join Hi, I have two tables with 8 buckets each on the same key and want to join them. I ran explain extended and get the plan produced by HIVE which shows that a map-side join is a possible plan. I then set in my script

Re: Question on bucketed map join

2012-01-24 Thread Avrilia Floratou
@hive.apache.org ReplyTo: user@hive.apache.org Subject: Re: Question on bucketed map join Hi Avrila AFAIK the bucketed map join is not default in hive and it happens only when the values is set to true. It could be because the same value is already set in the hive configuration xml file

Question on bucketed map join

2012-01-19 Thread Avrilia Floratou
Hi, I have two tables with 8 buckets each on the same key and want to join them. I ran explain extended and get the plan produced by HIVE which shows that a map-side join is a possible plan. I then set in my script the hive.optimize.bucketmapjoin option to true and reran the explain extended

Re: Question on bucketed map join

2012-01-19 Thread Bejoy Ks
From: Avrilia Floratou flora...@cs.wisc.edu To: user@hive.apache.org Sent: Thursday, January 19, 2012 9:23 PM Subject: Question on bucketed map join Hi, I have two tables with 8 buckets each on the same key and want to join them. I ran explain extended and get the plan produced

Re: Question on bucketed map join

2012-01-19 Thread bejoy_ks
@hive.apache.org Reply-To: user@hive.apache.org Subject: Re: Question on bucketed map join Hi Avrila    AFAIK the bucketed map join is not default in hive and it happens only when the values is set to true. It could be because the same value is already set in the hive configuration xml file. To cross