[HIVE-15796] HoS: poor reducer parallelism when operator stats are not accurate

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.2.0
• Fix Version/s: 2.3.0
• Component/s: Statistics
• Labels: TODOC2.2
• Assignee: Chao Sun
• Reporter: Chao Sun
• Created: 03/Feb/17 00:09
• Updated: 21/Jul/17 18:36
• Resolved: 22/Feb/17 17:31

Description

In HoS we use currently use operator stats to determine reducer parallelism. However, it is often the case that operator stats are not accurate, especially if column stats are not available. This sometimes will generate extremely poor reducer parallelism, and cause HoS query to run forever.

This JIRA tries to offer an alternative way to compute reducer parallelism, similar to how MR does. Here's the approach we are suggesting:
1. when computing the parallelism for a MapWork, use stats associated with the TableScan operator;
2. when computing the parallelism for a ReduceWork, use the maximum parallelism from all its parents.

Issue Links

• relates to: HIVE-16009 HoS: refactor set reducer parallelism