I found the answer, it because DATE dimension rowkey encode is date. When
executes "select APPID, SUM(IMPS) as imps from EXT_MID_EVENT_JOIN where
"DATE">=146206080 and "DATE"<146214720 group by APPID order by imps
desc limit 100", it returned right results. Btw, whether the date rowkey
Hi,
Top-N is usefull for one 'Top 10', but can be useful know the Sum of 'the
Others' (= sum (top > 10))
Example:
In a Shop Top 10 Sellers, sold 1.2M $
How much sold 'the others'? 1.2M $ its a lot respect the others?
I know that this is not easy to implement, but if someboy have any idea