[jira] [Commented] (TAJO-1793) result row count unmatched for UNION ALL

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

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

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

GitHub user blrunner opened a pull request:

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

    TAJO-1793: result row count unmatched for UNION ALL

    When executing an union all query, there isn't TableDesc in ```Query```.  As a result, the result stats of last stage will set output row number and volume. 
    
    To resolve this issue,  I summarized each result stats of all stages in union all query. But I found that the bytes number of stage changes occasionally. So, I just compare row number except bytes number in unit tests.

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

    $ git pull https://github.com/blrunner/tajo TAJO-1793

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

    https://github.com/apache/tajo/pull/902.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 #902
    
----
commit cb6b8583420f42ee82f9635a028d39193ecd60cc
Author: JaeHwa Jung <bl...@apache.org>
Date:   2015-12-03T08:47:19Z

    TAJO-1793: result row count unmatched for UNION ALL

----


> result row count unmatched for UNION ALL 
> -----------------------------------------
>
>                 Key: TAJO-1793
>                 URL: https://issues.apache.org/jira/browse/TAJO-1793
>             Project: Tajo
>          Issue Type: Bug
>          Components: QueryMaster
>    Affects Versions: 0.11.0
>         Environment: single node on Macbook
>            Reporter: Youngkyong Ko
>            Assignee: Jaehwa Jung
>            Priority: Critical
>             Fix For: 0.12.0, 0.11.1
>
>
> In UNION ALL, result record count is presented wrong. 
> default> select * from test1;
> c1
> -------------------------------
> 1
> 2
> (2 rows, 0.027 sec, 4 B selected)
> default> select * from test2;
> c1
> -------------------------------
> 2
> 3
> 4
> (3 rows, 0.011 sec, 6 B selected)
> default> select c1 from test1 union all select c1 from test2;
> Progress: 100%, response time: 0.458 sec
> c1
> -------------------------------
> 1
> 2
> 2
> 3
> 4
> (2 rows, 0.458 sec, 10 B selected)
> ==> SHOULD BE "5 rows" 
> BTW, it is OK in case of  UNION . 
> default> select c1 from test1 union  select c1 from test2;
> Progress: 100%, response time: 0.241 sec
> c1
> -------------------------------
> 2
> 1
> 3
> 4
> (4 rows, 0.241 sec, 8 B selected)



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