It probably depends on how big the big table is ... I mean if it can
be held in memory.
-Ajo
On Wed, Jan 19, 2011 at 11:23 PM, hadoop n00b wrote:
> Thanks Leo,
>
> Does the smaller table go into the mapjoin hint? Actually, when I ran a test
> query with the bigger table in the hint, it performed
Thanks Leo,
Does the smaller table go into the mapjoin hint? Actually, when I ran a test
query with the bigger table in the hint, it performed better.
On Thu, Jan 20, 2011 at 12:40 PM, Leo Alekseyev wrote:
> You can only specify one table, and make sure to include its name,
> i.e. /*+ mapjoin(t
You can only specify one table, and make sure to include its name,
i.e. /*+ mapjoin(t2)*/. For more info see
http://wiki.apache.org/hadoop/Hive/JoinOptimization and
http://www.slideshare.net/aiolos127/join-optimization-in-hive.
Also, you are using a relatively old version of Hive, but I'll let
m
