[ https://issues.apache.org/jira/browse/KYLIN-3089?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16288601#comment-16288601 ]
Yang Hao edited comment on KYLIN-3089 at 12/13/17 1:54 AM: ----------------------------------------------------------- This can be reproducted by using the data and cube in https://github.com/yanghaogn/KYLIN-3089, and executing {code:sql} select OPS_REGION,count(1) from KYLIN_SALES group by OPS_REGION; {code} was (Author: yanghaogn): This can be reproducted by using the data in https://github.com/yanghaogn/KYLIN-3089, and executing {code:sql} select OPS_REGION,count(1) from KYLIN_SALES group by OPS_REGION; {code} > Query exception on SortedIteratorMergerWithLimit > ------------------------------------------------ > > Key: KYLIN-3089 > URL: https://issues.apache.org/jira/browse/KYLIN-3089 > Project: Kylin > Issue Type: Bug > Components: Query Engine > Affects Versions: v2.1.0 > 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)