How does kylin deal with sub query??

[Bin.Li]

hello,


The sql is(sql1):


select channel_id,count(*) as shopper 
from 
(
select shopper_id, channel_id, count(*) 
from ods.ods_mobile_api 
where "DAY" = '20160315'
group by shopper_id,channel_id
) as t 
group by channel_id 
order by shopper desc 
;



This should be equal to(sql2):
select channel_id, count(distinct shopper_id) as shopper 
from ods_mobile_api 
where day = '20160315' 
group by channel_id 
order by shopper desc
;


And sql1, sql2 do can get the same results in hive, but different results 
between hive & kylin.
What the problem is ??


Many tks!!


bin.li