hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Namit Jain (JIRA)" <j...@apache.org>
Subject [jira] Issue Comment Edited: (HIVE-1750) Remove Partition Filtering Conditions when Possible
Date Wed, 03 Nov 2010 04:58:30 GMT

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


Mime
View raw message