Reviews and optimizes Hive on MapReduce jobs (table design, HQL, JOINs, data skew, MR tuning). Contains 26 citable rules. Use when optimizing HQL, diagnosing slow Hive jobs, handling skew, or designing partitioned/bucketed tables. Always check rules/ before advising and cite rule names.
