[
https://issues.apache.org/jira/browse/TAJO-661?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13921012#comment-13921012
]
Jihoon Son commented on TAJO-661:
---------------------------------
I'll investigate the cause of this error.
> 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)
