Jesus Camacho Rodriguez created HIVE-24154: ----------------------------------------------
Summary: Missing simplification opportunity with IN and EQUALS clauses Key: HIVE-24154 URL: https://issues.apache.org/jira/browse/HIVE-24154 Project: Hive Issue Type: Improvement Components: CBO Reporter: Jesus Camacho Rodriguez Assignee: Jesus Camacho Rodriguez For instance, in perf driver CBO query 74, there are several filters that could be simplified further: {code} HiveFilter(condition=[AND(=($1, 1999), IN($1, 1998, 1999))]) {code} This may lead to incorrect estimates and leads to unnecessary execution time. -- This message was sent by Atlassian Jira (v8.3.4#803005)