[jira] [Commented] (TAJO-1101) Broadcast join with a zero-length file table returns wrong result data.

["ASF GitHub Bot (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/TAJO-1101?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14161760#comment-14161760 ] 

ASF GitHub Bot commented on TAJO-1101:
--------------------------------------

GitHub user babokim opened a pull request:

    https://github.com/apache/tajo/pull/184

    TAJO-1101: Broadcast join with a zero-length file table returns wrong result data.

    

You can merge this pull request into a Git repository by running:

    $ git pull https://github.com/babokim/tajo TAJO-1101

Alternatively you can review and apply these changes as the patch at:

    https://github.com/apache/tajo/pull/184.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 #184
    
----
commit 5140517486cd634f1640d61f350e86c63090ebaa
Author: HyoungJun Kim <ba...@babokim-macbook-pro.local>
Date:   2014-10-07T10:38:49Z

    TAJO-1101: Broadcast join with a zero-length file table returns wrong result data.

----


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