Hi, I have replied to your question yesterday, but i am wondering whether you have received it.
Have you try the parameter `kylin.query.enable-dynamic-column=true` which can count the column without NULL values. Besides, I think this parameter should set to true by default as so many users are confusing about it. BRs, May ------------------ ???????? ------------------ ??????: "742093703"<[email protected]>; ????????: 2018??11??16??(??????) ????3:49 ??????: "user"<[email protected]>; ????: ??????????kylin?????????? !! ( Help !!! ) ?????????? ??kylin????????????????????model?? big_int_sum_model??Dimensions??11????Measures ?????? ?????? ??count, SUM, SUM, sum ????????bigint???????????????? sum_4g ??sum_wifi ??????????4g????????wifi?????? hive????????????430??????cube????????????kylin?????????? ?????????????????????????? ?? hive????kylin????????count??????????,????430?? ?? hive??????????4g?????????? 295763957458,WIFI?????????? 456897813426, ????kylin????????4g?????????? 89605527250, WIFI?????????? 164840037298?? ?????????????????????????????????????????????? ---------------------------------------------- Hello everyone! In the use of kylin, I set up a model called big_int_sum_model, 11 Dimensions, and 3 Measures are count, SUM and SUM respectively. Sum is the sum of two bigint fields, sum_4g and sum_wifi, to count the total traffic of 4G and wifi. The data in the hive table has 4 million 300 thousand. After cube, data can be found from kylin. But there is a strange phenomenon: The count results from the hive tables and kylin are the same, all 4 million 300 thousand. The total number of 4G traffic counted from the hive table is 295763957458, and the total number of WIFI traffic is 456897813426. However, the total number of 4G traffic statistics in kylin is 89605527250, and the total number of WIFI traffic is 164840037298. Can you enlighten me? In which direction should I think? [email protected]
