You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@kylin.apache.org by "Shaofeng SHI (JIRA)" <ji...@apache.org> on 2019/01/18 14:28:00 UTC

[jira] [Closed] (KYLIN-2011) Query without order by should not leverage topn measure

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

Shaofeng SHI closed KYLIN-2011.
-------------------------------
    Resolution: Duplicate
      Assignee:     (was: hongbin ma)

> Query without order by should not leverage topn measure
> -------------------------------------------------------
>
>                 Key: KYLIN-2011
>                 URL: https://issues.apache.org/jira/browse/KYLIN-2011
>             Project: Kylin
>          Issue Type: Bug
>          Components: Measure - TopN
>            Reporter: hongbin ma
>            Priority: Minor
>
> sql_topn/query45.sql:
> select seller_id, sum(price) as s from test_kylin_fact
>   where lstg_format_name='FP-GTC' 
>   group by seller_id
> this query does not have order by, however it will still leverage topn measure. Since topn use double encoding instead of decimal encoding, there's precision  loss.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)