[ 
https://issues.apache.org/jira/browse/KYLIN-4942?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

xue lin updated KYLIN-4942:
---------------------------
    Description: 
i set one dimension(fta_flag) encoding as boolean, but when i excute sql as 
below, it return Not sorted! last: exception.

select 
 fta_flag fta_flag
from fact_subscriber fs
where etl_dt = '20210319'
group by fta_flag

 

when i disable limit checkbox, it works

when i add order by fta_flag into sql, it works

issue 3089 may be related with my problem 
https://issues.apache.org/jira/browse/KYLIN-3089

  was:i set one dimension encoding as boolean, but when i excute sql as below, 
it return 


> dimension encoding boolean, query return Not sorted! last: exception
> --------------------------------------------------------------------
>
>                 Key: KYLIN-4942
>                 URL: https://issues.apache.org/jira/browse/KYLIN-4942
>             Project: Kylin
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: v3.0.2, v3.1.1
>            Reporter: xue lin
>            Priority: Major
>
> i set one dimension(fta_flag) encoding as boolean, but when i excute sql as 
> below, it return Not sorted! last: exception.
> select 
>  fta_flag fta_flag
> from fact_subscriber fs
> where etl_dt = '20210319'
> group by fta_flag
>  
> when i disable limit checkbox, it works
> when i add order by fta_flag into sql, it works
> issue 3089 may be related with my problem 
> https://issues.apache.org/jira/browse/KYLIN-3089



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Reply via email to