You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@tajo.apache.org by "Hyunsik Choi (JIRA)" <ji...@apache.org> on 2014/07/11 08:02:04 UTC

[jira] [Resolved] (TAJO-927) Broadcast Join with Large, Small, Large, Small tables makes a wrong plan.

     [ https://issues.apache.org/jira/browse/TAJO-927?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Hyunsik Choi resolved TAJO-927.
-------------------------------

       Resolution: Fixed
    Fix Version/s: 0.9.0

Thank you for nice bug fix. committed it to master branch.

> Broadcast Join with Large, Small, Large, Small tables makes a wrong plan.
> -------------------------------------------------------------------------
>
>                 Key: TAJO-927
>                 URL: https://issues.apache.org/jira/browse/TAJO-927
>             Project: Tajo
>          Issue Type: Bug
>            Reporter: Hyoungjun Kim
>            Assignee: Hyoungjun Kim
>            Priority: Minor
>             Fix For: 0.9.0
>
>
> {code:sql}
> select count(*) from large1 
> inner join small1 on large1_id = small1_id
> left outer join large2 on large1_id = large2_id 
> left outer join small2 on large1_id = small2_id
> {code}
> Current tajo planner makes the plan as following.  All large tables(large1, large2) are scanned in a single execution block. Each table should have a execution block. 
> {noformat}
> |-eb_1404871198908_0000_000005
>   |-eb_1404871198908_0000_000004
>     |-eb_1404871198908_0000_000003
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.2#6252)