[jira] [Updated] (KYLIN-2024) kylin TopN only support the first measure

["Shaofeng SHI (JIRA)" <ji...@apache.org>]

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

Shaofeng SHI updated KYLIN-2024:
--------------------------------
    Affects Version/s: v1.5.4
               Labels:   (was: newbie)
        Fix Version/s: v1.6.0

I reproduced the problem, will include the fix in next release. thanks for the reporting.

> kylin TopN only support the first measure 
> ------------------------------------------
>
>                 Key: KYLIN-2024
>                 URL: https://issues.apache.org/jira/browse/KYLIN-2024
>             Project: Kylin
>          Issue Type: Bug
>          Components: Job Engine
>    Affects Versions: v1.5.3, v1.5.4
>            Reporter: Kris
>            Assignee: Shaofeng SHI
>             Fix For: v1.6.0
>
>         Attachments: 截图 2016-09-18 15时18分54秒.jpg
>
>
> when I build cube chose top-N and select the group by column ,like this 
> TOP_N	SUM|ORDER BY:CLICK
> GROUP BY:MEDIA_SLOT
> TOP_N	
> SUM|ORDER BY:EREQ
> GROUP BY:MEDIA_SLOT
> TOP_N	
> SUM|ORDER BY:ECLICK
> GROUP BY:MEDIA_DOMAIN
> TOP_N	
> SUM|ORDER BY:REQUEST
> GROUP BY:MEDIA_DOMAIN
> if I use SQL likes "select MEDIA_SLOT ,sum(EREQ) ... ...group by (MEDIA_SLOT) order by sum(EREQ) desc /asc limit 100"  or group by(MEDIA_DOMAIN),sum(REQUEST) the result gets none.But if sum(CLICK) group by (MEDIA_SLOT) or sum(ECLICK) group by (MEDIA_DOMAIN) the result return true;
> Best whishes.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)