Jihoon Son created TAJO-661:
-------------------------------
Summary: Empty query results with the order by clause
Key: TAJO-661
URL: https://issues.apache.org/jira/browse/TAJO-661
Project: Tajo
Issue Type: Bug
Affects Versions: 1.0-incubating
Reporter: Jihoon Son
Consider the following query.
{noformat}
tajo> SELECT cache, sum(cnt) as sum_cnt from (
SELECT COUNT(totaltime) as cnt, cache FROM logs_20130409 GROUP BY cache
union
SELECT COUNT(totaltime) as cnt, cache FROM logs_20130408 GROUP BY cache
) as T GROUP BY T.cache ORDER BY cache;
{noformat}
The above query is successfully finished, but the query result is empty.
However, the same query without the order by cause return the valid results.
The type of 'cache' column is TEXT.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
