Hi Bejoy,
I am joining two tables which are both bucketed 64 ways and i want to do
a bucketed map join on them. I set the flag set hive.optimize.bucketmapjoin
= true;. The auto.convert.join is always false on our cluster. When i run
the following query:
select /*+ MAPJOIN(b) */ a.visitor_id FROM
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
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
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
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
explicitly set this to false
(set hive.optimize.buck
