I built a cube, it has 2 dimesions : CAMPAIGNID, DATE, and has 2 measures: count(1), topN(100). TOP-N is grouped by APPID and order by/sum by IMPS measure. When i queried: select APPID, SUM(IMPS) as imps from EXT_MID_EVENT_JOIN where "DATE">='2016-01-01' and "DATE"<'2016-01-08' group by APPID order by imps desc limit 100, it returned 0 records. Abviously there are a lot of records. Can someone explain why it always returned 0 records?
- TOP-N query always return 0 records 张天生
