One suggestion, such new feature should be enabled by default; Otherwise, most people won't know it, even we add it to the configuration list...
Ma Gang <mg4w...@163.com> 于2018年10月23日周二 下午3:17写道: > You may set the configuration 'kylin.query.enable-dynamic-column' to true > in kylin.properties, and test it. > > > At 2018-10-23 15:15:00, " 宋海涛" <hts...@gaojihealth.com> wrote: > > Hi Ma Gang, > > > > Thank you for your reply. The column ‘fzy_bill_code’ is from fact > table. > > But what do you mean about ‘enable dynamic column configuration.” > > > > Thanks. > > > > *发件人:* Ma Gang [mailto:mg4w...@163.com] > *发送时间:* 2018年10月23日 15:04 > *收件人:* user@kylin.apache.org > *主题:* Re:Re: Kylin Count(col) Result Is Different With Hive > > > > Is the column '*fzy_bill_code*' from fact table? If so, the issue should > have been fixed in https://issues.apache.org/jira/browse/KYLIN-3360, you > need to enable dynamic column configuration. > > > > > At 2018-10-23 14:11:46, "you Zhuang" <zhuangzixiao...@gmail.com> wrote: > > > http://apache-kylin.74782.x6.nabble.com/about-count-a-particular-column-in-kylin-td5579.html > > > > On 23 Oct 2018, at 10:27 AM, Haitao SONG <hts...@gaojihealth.com> wrote: > > > > > > Hi all, > > > > Run the same sql on kylin and hive, but got different result. It > seems kylin has count NULL as 1, but hive count it as 0. > > > > The sql is as below: > > * select count(fzy_bill_code) from gjst.sh_fetch_sale_base_fact > where dates between '2018-09-01' and '2018-10-18'* > > > > The result on kylin is : 2889422 , but 2688289 on hive. > > > > Anyone who knows the solution for this? Thanks a lot. > > > > Kylin Version: 2.5.0 > > > > Leo Song > > > > > > > > > > > > > > > -- Best regards, Shaofeng Shi 史少锋