Hi, have you try the parameter `kylin.query.enable-dynamic-column=true` which can count the column without NULL values.
BRs, May ------------------ ???????? ------------------ ??????: "George Ni"<[email protected]>; ????????: 2018??11??15??(??????) ????6:10 ??????: "dev"<[email protected]>; ????: Re: ??????????kylin?????????? Hi, have you queried with "select count(*) from {fact_table}" both in hive and kylin, and please check they have the same result. I doubt the segments you have built do not include all your hive data. Best regards, Chun??en Ni(George) ----- ???????? ----- ??????: [email protected] ??????: dev <[email protected]> ??????????: Thu, 15 Nov 2018 17:43:31 +0800 (CST) ????: ??????????kylin?????????? ?????????? ?????????????????????? ??kylin????????????????????model?????????? big_int_sum_model??Dimensions??11???? Measures ?????? ?????? ??count, SUM, SUM, sum ???? ????bigint???????????????? sum_4g ??sum_wifi ??????????4g????????wifi?????? hive????????????400??????cube????????????kylin?????????? ?????????????????????????? ?? hive??????????4g?????????? 295763957458 ,????kylin??????????????89605527250?? hive??????????WIFI?????????? 456897813426,????kylin??????????????164840037298?? ?????????????????????????????? [email protected]
