Hyoungjun Kim created TAJO-1101:
-----------------------------------

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

Reply via email to