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)