[HIVE-17914] Provide support for complex expressions in ON clauses for SEMIjoins

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 3.0.0
• Component/s: Operators, Parser
• Target Version/s: 3.0.0
• Assignee: Jesús Camacho Rodríguez
• Reporter: Jesús Camacho Rodríguez
• Created: 26/Oct/17 21:07
• Updated: 27/Feb/24 22:13
• Resolved: 26/Oct/17 21:10

Description

Similar to HIVE-15251, HIVE-15211.

Currently, we have some restrictions on the predicates that we can use in ON clauses for semi joins. It is important for subquery decorrelation to support complex conditions.

Issue Links

• duplicates: HIVE-17766 Support non-equi LEFT SEMI JOIN