Core concept
Broadcast when small table < hive.mapjoin.smalltable.filesize. SMB avoids shuffle.
Advertisement
How it works
Bad join strategy = huge shuffle. Skew joins need salting.
Advertisement
Trade-offs + gotchas
Star schema fact + dim. Common analytics.