[
https://issues.apache.org/jira/browse/HIVE-5119?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Laljo John Pullokkaran updated HIVE-5119:
-----------------------------------------
Description:
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
was: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.
> 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 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
