[HIVE-21928] Fix for statistics annotation in nested AND expressions

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Fix Version/s: 4.0.0-alpha-1
• Component/s: Physical Optimizer
• Labels: pull-request-available
• Assignee: Jesús Camacho Rodríguez
• Reporter: Jesús Camacho Rodríguez
• Created: 27/Jun/19 06:29
• Updated: 27/Feb/24 22:24
• Resolved: 09/Jul/19 15:21

Description

Discovered while working on HIVE-21867. Having predicates with nested AND expressions may result in different stats, even if predicates are basically similar (from stats estimation standpoint).
For instance, stats for AND(x=5, true, true) are different from x=5.

Issue Links

• relates to: HIVE-20260 NDV of a column shouldn't be scaled when row count is changed by filter on another column
• links to: GitHub Pull Request #700