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