Re: Question on bucketed map join

2012-03-26 Thread Amit Sharma
rds > Bejoy.K.S > > ------ > *From:* Avrilia Floratou > *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

Re: Question on bucketed map join

2012-01-25 Thread Bejoy Ks
2012 10:39 PM Subject: Re: Question on bucketed map join Hi Bejoy, Thanks a lot for your help:)  I'm still a little confused. In my script I always have the set.auto.convert.join = true. Then I did what you suggested: 1st -> set hive.optimize.bucketmapjoin=tru

Re: Question on bucketed map join

2012-01-24 Thread Avrilia Floratou
d. > > Hope it helps!.. > > Regards > Bejoy K S > From: Bejoy Ks > Date: Thu, 19 Jan 2012 09:22:08 -0800 (PST) > To: user@hive.apache.org > ReplyTo: user@hive.apache.org > Subject: Re: Question on bucketed map join > > Hi Avrila >AFAIK t

Re: Question on bucketed map join

2012-01-19 Thread bejoy_ks
e.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 confirm the same could you expli

Re: Question on bucketed map join

2012-01-19 Thread Bejoy Ks
y.K.S From: Avrilia Floratou 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 produce

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