hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From hadoop n00b <new2h...@gmail.com>
Subject Mapjoin Usage Question
Date Thu, 20 Jan 2011 07:00:50 GMT
Hi,

How do I use the mapjoin hint in a query.

Say, I have two tables t1 and t2 where t2 is the smaller table. Do I specify
t2 in the mapjoin hint?

select /*+ mapjoin(b)*/ * from t1 join t2 b on (a.id = b.id)

If I am joining two smaller tables, can I specify two clauses in the
mapjoin? /*+mapjoin(b,c)*/?

I am unable to find much documentation on this. I am using CDH2 with Hive
0.4.1

Thanks!

Mime
View raw message