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.