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

Reply via email to