hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ashutosh Chauhan (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-4878) With Dynamic partitioning, some queries would scan default partition even if query is not using it.
Date Mon, 22 Jul 2013 22:06:48 GMT

    [ https://issues.apache.org/jira/browse/HIVE-4878?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13715750#comment-13715750
] 

Ashutosh Chauhan commented on HIVE-4878:
----------------------------------------

Comment on RB.
                
> With Dynamic partitioning, some queries would scan default partition even if query is
not using it.
> ---------------------------------------------------------------------------------------------------
>
>                 Key: HIVE-4878
>                 URL: https://issues.apache.org/jira/browse/HIVE-4878
>             Project: Hive
>          Issue Type: Bug
>          Components: Query Processor
>    Affects Versions: 0.11.0
>            Reporter: Laljo John Pullokkaran
>            Assignee: Laljo John Pullokkaran
>             Fix For: 0.11.1
>
>         Attachments: pp2.patch
>
>
> With Dynamic partitioning, Hive would scan default partitions in some cases even if query
excludes it.
> As part of partition pruning, predicate is narrowed down to those pieces that involve
partition columns only. This predicate is then evaluated with partition values to determine,
if scan should include those partitions.
> But in some cases (like when comparing "__HIVE_DEFAULT_PARTITION__" to numeric data types)
expression evaluation would fail and would return NULL instead of true/false. In such cases
the partition is added to unknown partitions which is then subsequently scanned.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message