You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@kylin.apache.org by "Yang Hao (JIRA)" <ji...@apache.org> on 2017/12/07 13:08:00 UTC

[jira] [Commented] (KYLIN-3089) Query exception on SortedIteratorMergerWithLimit

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

Yang Hao commented on KYLIN-3089:
---------------------------------

There is only one segment in the case

> Query exception on SortedIteratorMergerWithLimit
> ------------------------------------------------
>
>                 Key: KYLIN-3089
>                 URL: https://issues.apache.org/jira/browse/KYLIN-3089
>             Project: Kylin
>          Issue Type: Bug
>            Reporter: Yang Hao
>
> The executing error only exists on some special case. I have a simple sql, and the query is routing onto SortedIteratorMergerWithLimit. When iterate data, it triggers such error
> {code:java}
>            //TODO: remove this check when validated
>             if (last != null) {
>                 if (comparator.compare(last, fetched) > 0)
>                     throw new IllegalStateException("Not sorted! last: " + last + " fetched: " + fetched);
>             }
> {code}
> sql is as belows. 
> {code:java}
> select "DATE",appid,dim_1,dim_2, sum(uv) as uv
> from table_1
> where appid = **** and "DATE" = 20171111  
> group by "DATE",appid,dim_1,dim_2
> limit 50000
> {code}



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)