[
https://issues.apache.org/jira/browse/TAJO-1101?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14162817#comment-14162817
]
ASF GitHub Bot commented on TAJO-1101:
--------------------------------------
Github user babokim commented on the pull request:
https://github.com/apache/tajo/pull/184#issuecomment-58282622
@hyunsik Thanks for your review. I'll commit soon.
> Broadcast join with a zero-length file table returns wrong result data.
> -----------------------------------------------------------------------
>
> Key: TAJO-1101
> URL: https://issues.apache.org/jira/browse/TAJO-1101
> Project: Tajo
> Issue Type: Bug
> Reporter: Hyoungjun Kim
> Assignee: Hyoungjun Kim
> Priority: Blocker
> Fix For: 0.9.0
>
>
> If a table has several data files and some files are empty, Broadcast join
> with that table returns wrong data.
> {code:sql}
> select * from customer_large a
> left outer join nation_multifile b on a.c_nationkey = b.n_nationkey
> where b.n_nationkey is null
> {code}
> The above query should return empty rows but return many rows with null
> n_nationkey value.
>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
