hi, Please provide as detailed as possible information, including the query SQL, query log, cube definition etc; Otherwise, we couldn't know what happened. Here is one recommended article on how to ask the question in a smart way:
http://catb.org/~esr/faqs/smart-questions.html Best regards, Shaofeng Shi 史少锋 Apache Kylin PMC Work email: [email protected] Kyligence Inc: https://kyligence.io/ Apache Kylin FAQ: https://kylin.apache.org/docs/gettingstarted/faq.html Join Kylin user mail group: [email protected] Join Kylin dev mail group: [email protected] May Zhou <[email protected]> 于2018年11月16日周五 下午4:53写道： > > 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] >
