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 <[email protected]> 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 > > >
