[HIVE-13815] Improve logic to infer false predicates

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.1.0
• Fix Version/s: 2.2.0
• Component/s: CBO
• Assignee: Jesús Camacho Rodríguez
• Reporter: Jesús Camacho Rodríguez
• Created: 21/May/16 19:56
• Updated: 27/Feb/24 22:23
• Resolved: 27/Jul/16 11:37

Description

Follow-up/extension of the work done in HIVE-13068.

Ex.
ql/src/test/results/clientpositive/annotate_stats_filter.q.out
predicate: ((year = 2001) and (state = 'OH') and (state = 'FL')) (type: boolean) -> false

ql/src/test/results/clientpositive/cbo_rp_join1.q.out
predicate: ((_col0 = _col1) and (_col1 = 40) and (_col0 = 40)) (type: boolean) -> predicate: ((_col1 = 40) and (_col0 = 40)) (type: boolean)

ql/src/test/results/clientpositive/constprog_semijoin.q.out
predicate: (((id = 100) = true) and (id <> 100)) (type: boolean) -> false

Issue Links

• is related to: HIVE-25919 ClassCastException when pushing boolean column predicate in HBaseStorageHandler
• relates to: HIVE-13068 Disable Hive ConstantPropagate optimizer when CBO has optimized the plan II
• links to: RB link