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

Reply via email to