[ https://issues.apache.org/jira/browse/HIVE-5119?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15027699#comment-15027699 ]
Laljo John Pullokkaran commented on HIVE-5119: ---------------------------------------------- This is fixed by DPP work. > MapJoin & Partition Pruning (MapJoin can take advantage of materialized data > to prune partitions of big table) > -------------------------------------------------------------------------------------------------------------- > > Key: HIVE-5119 > URL: https://issues.apache.org/jira/browse/HIVE-5119 > Project: Hive > Issue Type: Improvement > Components: Query Processor > Affects Versions: 0.11.0 > Reporter: Laljo John Pullokkaran > Assignee: Laljo John Pullokkaran > > Map-Join predicates where the joining columns from big table (streamed table) > are partition columns and corresponding columns from small table is not > partitioned, the join would not prune the unnecessary partitions from big > table. Since data for all small tables is materialized before big table is > streamed, theoretically it would be possible to prune the unnecessary > partitions from big table. > Proposal document is at https://cwiki.apache.org/confluence/x/sgkHAg -- This message was sent by Atlassian JIRA (v6.3.4#6332)