Condition for doing a sort merge bucket map join

2012-05-22 Thread Bruce Bian
Hi , I've got 7 large tables to join(each ~10G in size) into one table, all with the same* 2 *join keys, I've read some documents on sort merge bucket map join, but failed to fire that. I've bucketed all the 7 tables into 20 buckets and sorted by one of the join key, set

Re: Condition for doing a sort merge bucket map join

2012-05-22 Thread Mark Grover
- Original Message - From: Bruce Bian weidong@gmail.com To: user@hive.apache.org Sent: Tuesday, May 22, 2012 11:07:38 AM Subject: Condition for doing a sort merge bucket map join Hi , I've got 7 large tables to join(each ~10G in size) into one table, all with the same 2 join keys, I've read