[HIVE-16940] Residual predicates in join operator prevent vectorization

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 3.0.0
• Component/s: Vectorization
• Target Version/s: 3.0.0
• Assignee: Unassigned
• Reporter: Jesús Camacho Rodríguez
• Created: 22/Jun/17 07:23
• Updated: 27/Feb/24 22:23

Description

With HIVE-16885, filter predicates in ON clause for INNER joins are pushed within the join operator (residual predicates in the operator). Previously, residual predicates were only used for OUTER join operators.

Currently, vectorization does not support the evaluation of residual predicates that are within an INNER join, and thus, it gets disabled if the filter expression is pushed within the join. We should implement the vectorization of INNER join in the presence of residual predicates.

Issue Links

• is related to: HIVE-17766 Support non-equi LEFT SEMI JOIN
• relates to: HIVE-16885 Non-equi Joins: Filter clauses should be pushed into the ON clause