Core concept
hive.cbo.enable. Stats must exist (ANALYZE TABLE).
Advertisement
How it works
Poor stats = poor CBO decisions. Sometimes CBO worse than manual.
Advertisement
Trade-offs + gotchas
Every analytical query. Especially multi-way joins.