Hi, How large is t1 and t2 ? if both of t1 and t2 is larger than 25M (a default threshold), the query processor will do the common join.
Thanks Liyin On 23 December 2010 18:50, <ash...@gmail.com> wrote: > Hi, > > I set hive.auto.convert.join=true and run the following query: > > select t1.foo, count(t2.bar) from invites t1 join invites t2 on > (t1.foo=t2.foo) group by t1.foo; > > I did not see it ran as map side join. Did I miss something? Is there any > precondition for this feature to work? > > Thanks. > -- Best Regards -Liyin
