hive-dev mailing list archives

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


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.

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

> 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