[
https://issues.apache.org/jira/browse/HIVE-1750?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12924846#action_12924846
]
Namit Jain commented on HIVE-1750:
----------------------------------
Note that it is different from HIVE-1538.
For eg, if T is partitioned on ds,
and the query is:
select c1 from T where ds = '1' and c2 > 10;
There is no reason to apply the filter ds='1' for each row. Partition pruning
has already taken care of it.
However, for a query like:
select .. from T where (ds='1' and x >1) or (ds='2' and x < 10);
We need the predicates on partitioning column 'ds'.
> 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
>
> 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.
