[jira] [Created] (HIVE-5119) MapJoin & Partition Pruning (MapJoin can take advantage of materialized data to prune partitions of big table)

["Laljo John Pullokkaran (JIRA)" <ji...@apache.org>]

Laljo John Pullokkaran created HIVE-5119:
--------------------------------------------

             Summary: 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.

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