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

Posted to dev@kylin.apache.org by "Kris (JIRA)" <ji...@apache.org> on 2016/09/18 07:04:20 UTC

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

Kris created KYLIN-2024:
---------------------------

             Summary: 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
            Reporter: Kris
            Assignee: Dong Li


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 retrun true;
Best whishes.




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