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

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

Github user jinossy commented on a diff in the pull request:

    https://github.com/apache/tajo/pull/1009#discussion_r61996618
  
    --- Diff: 
tajo-cluster-tests/src/test/java/org/apache/tajo/TpchTestBase.java ---
    @@ -92,6 +92,7 @@ private void setUp() throws Exception {
         util = new LocalTajoTestingUtility();
         KeyValueSet opt = new KeyValueSet();
         opt.set(StorageConstants.TEXT_DELIMITER, 
StorageConstants.DEFAULT_FIELD_DELIMITER);
    +    opt.set(StorageConstants.TEXT_NULL, "\\\\N");
    --- End diff --
    
    Looks like you are not apply default null character in meta. 


> Invalid join result when join key columns contain nulls
> -------------------------------------------------------
>
>                 Key: TAJO-2135
>                 URL: https://issues.apache.org/jira/browse/TAJO-2135
>             Project: Tajo
>          Issue Type: Bug
>    Affects Versions: 0.11.0
>            Reporter: Jihoon Son
>            Assignee: Jihoon Son
>            Priority: Critical
>             Fix For: 0.12.0, 0.11.3
>
>
> You can simply reproduce this bug as follows. The correct answer of the below 
> query is 20965674.
> {noformat}
> tpcds100> select count(*) from store_sales, store_returns 
> where 
> ss_customer_sk = sr_customer_sk 
> and ss_item_sk = sr_item_sk 
> ;
> [=========================================>] 100%  33.315 sec
> ?count
> -------------------------------
> 101145653
> (1 rows, 33.315 sec, 16 B selected)
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to