kylin-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Yang Hao (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (KYLIN-3089) Query exception on SortedIteratorMergerWithLimit
Date Thu, 07 Dec 2017 13:06:00 GMT

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

Mime
View raw message