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:06:00 UTC
[jira] [Updated] (KYLIN-3089) Query exception on
SortedIteratorMergerWithLimit
[ https://issues.apache.org/jira/browse/KYLIN-3089?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Yang Hao updated KYLIN-3089:
----------------------------
Description:
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}
was:
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 KYLIN_CUSTOM_MIDDLETIER
where appid = **** and "DATE" = 20171111
group by "DATE",appid,dim_1,dim_2
limit 50000
{code}
> 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)