Core concept
Both tables CLUSTERED BY same col into same buckets, SORTED BY same. hive.enforce.sortmergebucketmapjoin=true.
Advertisement
How it works
Bucket count fixed at create. Change requires table rewrite.
Advertisement
Trade-offs + gotchas
Frequent joins on same key. Data warehouse dimensions.