[HIVE-24203] Implement stats annotation rule for the LateralViewJoinOperator

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.3.7, 3.1.2, 4.0.0
• Fix Version/s: 4.0.0-alpha-1
• Component/s: Physical Optimizer
• Labels: pull-request-available
• Assignee: Shohei Okumiya
• Reporter: Shohei Okumiya
• Created: 28/Sep/20 03:06
• Updated: 17/Nov/22 08:47
• Resolved: 13/Jan/21 08:07

Description

StatsRulesProcFactory doesn't have any rules to handle a JOIN by LATERAL VIEW.

This can cause an underestimation in case that UDTF in LATERAL VIEW generates multiple rows.

HIVE-20262 has already added the rule for UDTF.

This issue would add the rule for LateralViewJoinOperator.

Issue Links

• relates to: HIVE-20262 Implement stats annotation rule for the UDTFOperator
• links to: GitHub Pull Request #1531