I meet this problem and I use Global dictionary for sloveing it ------------------ 原始邮件 ------------------ 发件人: "ShaoFeng Shi" <[email protected]>; 发送时间: 2018年1月11日(星期四) 16:58 收件人: "dev" <[email protected]>; 主题: Re: Calculate count distinct with 2 segments not correct
Hi yousheng, Whatever the time range you queried, the result of count distinct should/need be correct. And the segment merge shouldn't change the query result. What's your Kylin version? Did you use the GlobalDictionary for the column that doing distinct count? 2018-01-11 15:57 GMT+08:00 张 佑铖 <[email protected]>: > Hi Kylin team, > > > > In my cube, partition by date, auto merge by 7 days. > > And I use bitmap for count distinct. > > The case is I have 2 segments which is 20171229-20180105 and > 20180105-20180112, I found that if the time of query in both 2 segments, > the result of count distinct is not correct, > > after I merge the 2 segments and finally the result seems correct. > > So I have the question, if I want to calculate a count distinct with > whenever start and whenever end, I should always merge all the segments? > > > Thank you > -- Best regards, Shaofeng Shi 史少锋
