[
https://issues.apache.org/jira/browse/HIVE-1750?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12927735#action_12927735
]
Namit Jain edited comment on HIVE-1750 at 11/3/10 12:58 AM:
------------------------------------------------------------
The code changes look good to me.
Can you add some tests and do a explain plan for all kinds of scenarios:
ds < 10 and x > 5
ds < 10 or x > 5
ds < 10 and x > 5 and y > 10
(ds < 10 and x > 5) or (ds > 10 and y > 5)
(ds < 10 and x > 5) or (ds > 5 and y > 5)
(ds < 10 or x > 5) and (ds > 5 or y > 5)
was (Author: namit):
The code changes look good to me.
Can you add some tests and do a explain plan for all kinds of scenarios:
ds < 10 and x > 5
ds < 10 or x > 5
ds < 10 and x > 5 and y > 10
(ds < 10 and x > 5) or (ds > 10 and y > 5)
(ds < 10 and x > 5) or (ds > 5 and y > 5)
> Remove Partition Filtering Conditions when Possible
> ---------------------------------------------------
>
> Key: HIVE-1750
> URL: https://issues.apache.org/jira/browse/HIVE-1750
> Project: Hive
> Issue Type: Improvement
> Reporter: Siying Dong
> Assignee: Siying Dong
> Attachments: HIVE-1750.1.patch, HIVE-1750.2.patch, HIVE-1750.3.patch
>
>
> For some simple queries, partition filtering constraints take 8% of CPU time
> (now 16% since we filter twice) even if the result is always true. When
> possible, we should remove these constraints to save CPU times.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
