Core concept

hive.auto.convert.join, mapjoin.smalltable, dynamic partition modes.

Advertisement

How it works

Trial + error. Some settings interact.

Advertisement

Trade-offs + gotchas

Slow query debugging.