When you talk about mismatch result, you'd better provide the sample data and actual result. Otherwise, nobody could reproduce your issue easily.
2016-12-27 16:13 GMT+08:00 徐 鹏 <[email protected]>: > HI all: > Query1: > SELECT COUNT(DISTINCT CASE WHEN pagefiltername IN > (‘homepage') THEN t.loginkey END) AS homepageuv > FROM fly t > WHERE yyyymmdd='20161222’ > Query2: > SELECT COUNT(DISTINCT t.loginkey ) AS homepageuv FROM fly > t WHERE yyyymmdd='20161222' and pagefiltername IN ('homepage') ; > > expected :Query1=Query2 > actual:Query1 !=Query2 > > What’s wrong? > > > Regards, > Peng Xu > [email protected] > > > > > > >
