[
https://issues.apache.org/jira/browse/TAJO-929?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14057468#comment-14057468
]
ASF GitHub Bot commented on TAJO-929:
-------------------------------------
GitHub user babokim opened a pull request:
https://github.com/apache/tajo/pull/66
TAJO-929: Broadcast join with empty outer join table returns empty result.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/babokim/tajo TAJO-929
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/tajo/pull/66.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #66
----
commit 893f16a01460b648a9b8f3368a183694c14924c2
Author: 김형준 <[email protected]>
Date: 2014-07-10T13:04:53Z
TAJO-929: Broadcast join with empty outer join table returns empty result.
commit 186ae11f3ad8de0192cd367a35ff0ac8a76ccd7e
Author: 김형준 <[email protected]>
Date: 2014-07-10T13:41:11Z
TAJO-929: Broadcast join with empty outer join table returns empty result.
----
> Broadcast join with empty outer join table returns empty result.
> ------------------------------------------------------------------
>
> Key: TAJO-929
> URL: https://issues.apache.org/jira/browse/TAJO-929
> Project: Tajo
> Issue Type: Bug
> Reporter: Hyoungjun Kim
> Assignee: Hyoungjun Kim
> Priority: Minor
>
> The below query returns empty result. customer_parts table is partitioned
> table by c_custkey column. Orders table is inner join and customer_parts is
> outer join.
> {code:sql}
> select a.l_orderkey, b.o_orderkey, c.c_custkey from lineitem a
> inner join orders b on a.l_orderkey = b.o_orderkey
> left outer join customer_parts c on a.l_orderkey = c.c_custkey and
> c.c_custkey < 0
> {code}
> Repartitioner class doesn't consider mixed join operator(inner and outer). In
> the upper query case there is three scans stats. customer_parts's stat is
> zero but customer_parts is outer join.
> {code}
> JoinNode joinNode = PlannerUtil.findMostBottomNode(execBlock.getPlan(),
> NodeType.JOIN);
> if (joinNode != null) {
> if ( (joinNode.getJoinType() == JoinType.INNER)) {
> for (int i = 0; i < stats.length; i++) {
> if (stats[i] == 0) {
> return;
> }
> }
> }
> }
> {code}
--
This message was sent by Atlassian JIRA
(v6.2#6252)
