[
https://issues.apache.org/jira/browse/KYLIN-2024?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Kris updated KYLIN-2024:
------------------------
Description:
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.
was:
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.
> 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
>
> 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)
