hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Vikram Dixit K (JIRA)" <>
Subject [jira] [Updated] (HIVE-3891) physical optimizer changes for auto sort-merge join
Date Thu, 28 Feb 2013 09:01:17 GMT


Vikram Dixit K updated HIVE-3891:

    Attachment: auto_sortmerge_join_1.q.out

Hi Namit,

I have added some more variations to the queries in auto_sortmerge_join_1.q. I originally
did not catch that there was a SMB map join in stage-1. That as you say is correct. One thing
I see is that if I try to join sorted, bucketed tables on different keys (last join in the
attached file), I see a SMB Map join operator followed by a reduce side join. It seems like
the reduce side join could actually become a map join operator. Is this possible?

> physical optimizer changes for auto sort-merge join
> ---------------------------------------------------
>                 Key: HIVE-3891
>                 URL:
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Namit Jain
>            Assignee: Namit Jain
>         Attachments: auto_sortmerge_join_1.q, auto_sortmerge_join_1.q.out, hive.3891.1.patch,
hive.3891.2.patch, hive.3891.3.patch, hive.3891.4.patch, hive.3891.5.patch, hive.3891.6.patch,

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:

View raw message