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
