[jira] Commented: (HIVE-1538) FilterOperator is applied twice with ppd on.

["Amareshwari Sriramadasu (JIRA)" <ji...@apache.org>]

    [ 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.