[jira] [Commented] (TAJO-661) Empty query results with the order by clause

["Jihoon Son (JIRA)" <ji...@apache.org>]

    [ 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)