[HIVE-19500] Prevent multiple selectivity estimations for the same variable in conjuctions

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.1.0, 3.0.0
• Fix Version/s: 3.1.0, 4.0.0-alpha-1
• Target Version/s: 3.1.0, 3.0.0
• Assignee: Zoltan Haindrich
• Reporter: Zoltan Haindrich
• Created: 11/May/18 11:43
• Updated: 27/Feb/24 22:23
• Resolved: 25/May/18 12:15

Description

see HIVE-19097 for problem description

for filters like: (d_year in (2001,2002) and d_year = 2001) the current estimation is around (1/NDV)**2 (iff column stats are available) ....

actually the source of the problem was a small typo in HIVE-17465