hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Amareshwari Sriramadasu (JIRA)" <>
Subject [jira] Commented: (HIVE-1538) FilterOperator is applied twice with ppd on.
Date Tue, 09 Nov 2010 06:11:24 GMT


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

View raw message