hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Navis (JIRA)" <>
Subject [jira] [Commented] (HIVE-3639) join order across mutiple joins
Date Tue, 30 Oct 2012 08:46:13 GMT


Navis commented on HIVE-3639:

If join type is same, reordering could be a good optimization point. Doing HIVE-3464, I've
had similar thoughts.
> join order across mutiple joins
> -------------------------------
>                 Key: HIVE-3639
>                 URL:
>             Project: Hive
>          Issue Type: Improvement
>          Components: Query Processor
>            Reporter: Namit Jain
> This came up during a discussion with Sambavi - please add any details I may
> have missed.
> For a query of the form:
> select ..
> from
> A join B on A.c1 = B.c1
> join C on B.c2=C.c2;
> A,B are joined first and the result is then joined with C.
> This is clearly sub-optimal if A is the largest table, in which case
> B and C should be joined first, and then the result should be joined with A.

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