[HIVE-24154] Missing simplification opportunity with IN and EQUALS clauses

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 4.0.0-alpha-1
• Component/s: CBO
• Labels: pull-request-available
• Assignee: Jesús Camacho Rodríguez
• Reporter: Jesús Camacho Rodríguez
• Created: 13/Sep/20 01:23
• Updated: 27/Feb/24 22:13
• Resolved: 30/Sep/20 20:07

Description

For instance, in perf driver CBO query 74, there are several filters that could be simplified further:

HiveFilter(condition=[AND(=($1, 1999), IN($1, 1998, 1999))])

This may lead to incorrect estimates and leads to unnecessary execution time.

Issue Links

• links to: GitHub Pull Request #1492