[
https://issues.apache.org/jira/browse/HIVE-1538?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12929976#action_12929976
]
Amareshwari Sriramadasu commented on HIVE-1538:
-----------------------------------------------
There are a couple of issues in removing the original filter operator.
# All the expressions in the filter predicate may not be pushed.
** I'm planning to create a filter operator with non-final candidates as a
child of the original filter op and mark the original filter op for deletion.
# The candidate predicates may not pushed past some operators. For ex. Outer
Join operator does not allow candidates for all aliases; LIMIT/SCRIPT/UDTF
operators do not push any predicates.
** I'm planning to create a filter operator with unpushed predicates, as a
child of the operator through which the predicates could not be pushed.
Finally, remove the original filter operators which are marked for deletion.
Thoughts? Any suggestions?
> FilterOperator is applied twice with ppd on.
> --------------------------------------------
>
> Key: HIVE-1538
> URL: https://issues.apache.org/jira/browse/HIVE-1538
> Project: Hive
> Issue Type: Bug
> Components: Query Processor
> Reporter: Amareshwari Sriramadasu
> Assignee: Amareshwari Sriramadasu
>
> With hive.optimize.ppd set to true, FilterOperator is applied twice. And it
> seems second operator is always filtering zero rows.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
