[jira] [Commented] (TAJO-585) TajoCli prints unexpected results in simple union query.

["Tajo QA (JIRA)" <ji...@apache.org>]

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

Tajo QA commented on TAJO-585:
------------------------------

{color:red}*-1 overall.*{color}  Here are the results of testing the latest attachment 
  http://issues.apache.org/jira/secure/attachment/12627330/TAJO-585.patch
  against master revision 009e025.

    {color:green}+1 @author.{color}  The patch does not contain any @author tags.

    {color:green}+1 tests included.{color}  The patch appears to include 4 new or modified test files.

    {color:green}+1 javac.{color}  The applied patch does not increase the total number of javac compiler warnings.

    {color:green}+1 javadoc.{color}  The applied patch does not increase the total number of javadoc warnings.

    {color:green}+1 checkstyle.{color}  The patch generated 0 code style errors.

    {color:red}-1 findbugs.{color}  The patch appears to introduce 194 new Findbugs (version 1.3.9) warnings.

    {color:green}+1 release audit.{color}  The applied patch does not increase the total number of release audit warnings.

    {color:red}-1 core tests.{color}  The patch failed these unit tests in tajo-client tajo-core/tajo-core-backend: 
                  org.apache.tajo.engine.query.TestGroupByQuery
                  org.apache.tajo.engine.query.TestUnionQuery
                  org.apache.tajo.engine.query.TestCTASQuery

Test results: https://builds.apache.org/job/PreCommit-TAJO-Build/110//testReport/
Findbugs warnings: https://builds.apache.org/job/PreCommit-TAJO-Build/110//artifact/incubator-tajo/patchprocess/newPatchFindbugsWarningstajo-core-backend.html
Console output: https://builds.apache.org/job/PreCommit-TAJO-Build/110//console

This message is automatically generated.

> TajoCli prints unexpected results in simple union query.
> --------------------------------------------------------
>
>                 Key: TAJO-585
>                 URL: https://issues.apache.org/jira/browse/TAJO-585
>             Project: Tajo
>          Issue Type: Bug
>          Components: query master
>    Affects Versions: 0.8-incubating
>            Reporter: Jaehwa Jung
>            Assignee: Jaehwa Jung
>             Fix For: 0.8-incubating
>
>         Attachments: TAJO-585.patch
>
>
> I found a bug which TajoCli prints unexpected results in union query.
> For the first, TajoCli prints wrong row numbers as follows:
> {code:xml}
> tajo> select id from table1 union all select id from table2;
> result: hdfs://localhost:9010/tmp/tajo-blrunner/staging/q_1391680780275_0004/RESULT, 5 rows (21 B)
> id
> -------------------------------
> 6
> 7
> 8
> 9
> 10
> 1
> 2
> 3
> 4
> 5
> {code}
> And if empty table located on last phase, it just prints zero as follows:
> {code:xml}
> tajo> select id from table1 union all select id from table3;
> result: hdfs://localhost:9010/tmp/tajo-blrunner/staging/q_1391680780275_0005/RESULT, 0 rows (10 B)
> id
> -------------------------------
> {code}
> For reference, I created test tables as follows:
> {code:xml}
> CREATE EXTERNAL TABLE table1 (id INT4, name TEXT, score FLOAT4, type TEXT) USING CSV WITH ('csvfile.delimiter'='|') LOCATION 'hdfs://localhost:9010/tajo/warehouse/table1';
> CREATE EXTERNAL TABLE table2 (id INT4, name TEXT, score FLOAT4, type TEXT) USING CSV WITH ('csvfile.delimiter'='|') LOCATION 'hdfs://localhost:9010/tajo/warehouse/table2';
> CREATE EXTERNAL TABLE table3 (id INT4, name TEXT, score FLOAT4, type TEXT) USING CSV WITH ('csvfile.delimiter'='|') LOCATION 'hdfs://localhost:9010/tajo/warehouse/table3';
> tajo> select * from table1;
> result: hdfs://localhost:9010/tmp/tajo-blrunner/staging/q_1391680780275_0001/RESULT, 5 rows (60 B)
> id,  name,  score,  type
> -------------------------------
> 1,  ooo,  1.1,  a
> 2,  ppp,  2.3,  b
> 3,  qqq,  3.4,  c
> 4,  rrr,  4.5,  d
> 5,  xxx,  5.6,  e
> tajo> select * from table2;
> result: hdfs://localhost:9010/tmp/tajo-blrunner/staging/q_1391680780275_0002/RESULT, 5 rows (61 B)
> id,  name,  score,  type
> -------------------------------
> 6,  ooo,  1.1,  a
> 7,  ppp,  2.3,  b
> 8,  qqq,  3.4,  c
> 9,  rrr,  4.5,  d
> 10,  xxx,  5.6,  e
> tajo> select * from table3;
> result: hdfs://localhost:9010/tmp/tajo-blrunner/staging/q_1391680780275_0003/RESULT, 0 rows (0 B)
> id,  name,  score,  type
> -------------------------------
> {code}



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)