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

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

Hyoungjun Kim created TAJO-927:
----------------------------------

             Summary: 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


{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)