hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Vikram Dixit K (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-3891) physical optimizer changes for auto sort-merge join
Date Fri, 01 Mar 2013 05:17:13 GMT

    [ https://issues.apache.org/jira/browse/HIVE-3891?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13590250#comment-13590250
] 

Vikram Dixit K commented on HIVE-3891:
--------------------------------------

Hi Namit,

The test case I have is very similar to the star join case. I have a 4 way join with 3 dimension
tables and 1 fact table. All the joins are on different keys. By default, the average partition
size is used as the tie breaker for the choice of big table. However when I run this query,
I get the array out of bounds exception as it chose the table from the 2nd join (T3 from below)
as the big table (index = 2). However, the joinCtx right alias has only one table. So this
resulted in a crash.

{noformat}
T1 \
      J1.out \
T2 /           J2.out \
          T3 /          J3.out (Final)
                   T4 /
{noformat}

Thanks
Vikram.
                
> physical optimizer changes for auto sort-merge join
> ---------------------------------------------------
>
>                 Key: HIVE-3891
>                 URL: https://issues.apache.org/jira/browse/HIVE-3891
>             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,
hive.3891.7.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: http://www.atlassian.com/software/jira

Mime
View raw message