Bin, could you open a JIRA on this? It must be a bug. On Thu, Mar 24, 2016 at 1:11 PM, ShaoFeng Shi <[email protected]> wrote:
> Which SQL in kylin returns a different result by comparing to hive? sql2, > or both? > > 2016-03-24 11:53 GMT+08:00 Bin.Li <[email protected]>: > >> 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 >> > > > > -- > Best regards, > > Shaofeng Shi > >
