[HIVE-9186] Remove predicates from filter operators that have been pushed to StorageHandler

• Type: Improvement
• Status: Patch Available
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 0.12.0
• Component/s: Logical Optimizer, StorageHandler
• Labels: patch
• Assignee: Unassigned
• Reporter: rvince800
• Created: 21/Dec/14 14:22
• Updated: 26/Mar/15 16:21

Description

When the residual predicate is null, pushed down predicates are evaluated twice, by the StorageHander and later by the filter operator. In addition to the performance penalty, some specific pushed predicates may not be correctly handled by the filter operator, thus masking some results returned by the StorageHandler.

As proposed in HIVE-2897 with other changes, the provided patch only removes pushed predicates when residual predicate is null.

Issue Links

• duplicates: HIVE-2897 Remove filter operator of which all the predicates have pushed down to storage handler