You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@tajo.apache.org by "JaeHwa Jung (JIRA)" <ji...@apache.org> on 2013/12/18 10:53:07 UTC
[jira] [Created] (TAJO-429) UNION clause has a problem in
sub-query.
JaeHwa Jung created TAJO-429:
--------------------------------
Summary: UNION clause has a problem in sub-query.
Key: TAJO-429
URL: https://issues.apache.org/jira/browse/TAJO-429
Project: Tajo
Issue Type: Bug
Reporter: JaeHwa Jung
If UNION clause write in SubQuery clause, TajoCli doesn't print any data.
I found that UNION query is right as follows:
{code:xml}
tajo> select a.id, a.name from table1 a union select b.id, b.name from table4 b ;
Progress: 100%, response time: 0.382 sec
final state: QUERY_SUCCEEDED, response time: 0.382 sec
result: hdfs://localhost:9010/tmp/tajo-blrunner/staging/q_1387355494232_0050/RESULT, 6 rows (72 B)
id, name
-------------------------------
12, c02
13, c03
14, c04
15, c05
16, d01
17, d02
1, ooo
2, ppp
3, qqq
4, rrr
5, xxx
tajo>
{code}
But, if I use UNION query in sub-query, there isn't any result data as follows:
{code:xml}
tajo> select * from (select a.id, a.name from table1 a union select b.id, b.name from table4 b) t;
Progress: 100%, response time: 0.396 sec
final state: QUERY_SUCCEEDED, response time: 0.396 sec
result: hdfs://localhost:9010/tmp/tajo-blrunner/staging/q_1387355494232_0051/RESULT, 11 rows (0 B)
id, name
-------------------------------
tajo>
{code}
--
This message was sent by Atlassian JIRA
(v6.1.4#6159)