[ https://issues.apache.org/jira/browse/HIVE-4878?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13718788#comment-13718788 ]
Laljo John Pullokkaran commented on HIVE-4878: ---------------------------------------------- Resubmitted the patch to do partition skip regardless of "Dynamic Partition Mode". This fix avoids scanning default partition if all of the following is true: a) partition pruning expression failed to evaluate for a given partition. b) at the least one of the columns in the partition is default partition. > 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: HIVE-4878.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