The behavior resembles KYLIN-2341. Still worth a new JIRA to track. https://issues.apache.org/jira/browse/KYLIN-2500
On Thu, Mar 9, 2017 at 2:48 PM, Roy <[email protected]> wrote: > Hi there, > > Use kylin insight submit below sentence, > ------------------------------------------select > sentence------------------------------------------ > select > count(distinct memberid) as memberid, > count(distinct case when issuccess=1 then memberid else -1 end) as > Xmemberid > from > tables > where istest=0 and isvalid=1 and createdate>='2017-03-08' > > results > memberid Xmemberid > > 863049 863049 > ------------------------------------ > > retrun the same results,if add condittion include where the results is > ------------------------------------------------------condittion in where > --------------------------------- > select > count(distinct memberid) as Xmemberid > from > tables > where istest=0 and isvalid=1 and issuccess=1 and createdate>='2017-03-08' > > results > memberid > 637290 > ---------------------------------- > > Why appear this problem,anyone has encountered a similar situcation? > > Best Regards > > Roy > > > > > > >
