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)

Reply via email to