[DRILL-2327] Upper bound on join's row_count_estimate_factor should be increased to handle expanding joins

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.8.0
• Component/s: Query Planning & Optimization
• Assignee: Aman Sinha
• Reporter: Aman Sinha
• Created: 27/Feb/15 00:25
• Updated: 27/Feb/15 22:33
• Resolved: 27/Feb/15 22:33

Description

The current bounds for planner.join.row_count_estimate_factor is between 0 to 100. The default value is 1.0. This parameter determines the estimated output cardinality of a join. For hugely expanding joins, this is inadequate and we need to allow substantially larger upper bound.