[ https://issues.apache.org/jira/browse/KYLIN-2024?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kris updated KYLIN-2024: ------------------------ Attachment: 截图 2016-09-18 15时18分54秒.jpg only the sum(click) group by (MEDIA_SLOT) and sum(ECLICK) group by (MEDIA_DOMAIN) can get result > 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 > Labels: newbie > 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)