You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@kylin.apache.org by ShaoFeng Shi <sh...@apache.org> on 2018/11/17 14:11:51 UTC
Re: 大神，求助kylin的使用问题 !! ( Help !!! )
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: shaofeng.shi@kyligence.io
Kyligence Inc: https://kyligence.io/
Apache Kylin FAQ: https://kylin.apache.org/docs/gettingstarted/faq.html
Join Kylin user mail group: user-subscribe@kylin.apache.org
Join Kylin dev mail group: dev-subscribe@kylin.apache.org
May Zhou <ma...@foxmail.com> 于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"<74...@qq.com>;
> *发送时间:* 2018年11月16日(星期五) 下午3:49
> *收件人:* "user"<us...@kylin.apache.org>;
> *主题:* 大神，求助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?
>
>
>
> ------------------------------
> 742093703@qq.com
>
Re: 大神，求助kylin的使用问题 !! ( Help !!! )
Posted by Luke Han <lu...@gmail.com>.
Please do not use 大神" and "Help!!!" in mail subject, and it's better to
raise your question in English (at least
for the subject).
The community is based on volunteers and there's no guarantee for the
answers (although the community
will try the best to help).
Thanks.
Best Regards!
---------------------
Luke Han
On Sat, Nov 17, 2018 at 10:12 PM ShaoFeng Shi <sh...@apache.org>
wrote:
> 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: shaofeng.shi@kyligence.io
> Kyligence Inc: https://kyligence.io/
>
> Apache Kylin FAQ: https://kylin.apache.org/docs/gettingstarted/faq.html
> Join Kylin user mail group: user-subscribe@kylin.apache.org
> Join Kylin dev mail group: dev-subscribe@kylin.apache.org
>
>
>
>
> May Zhou <ma...@foxmail.com> 于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"<74...@qq.com>;
>> *发送时间:* 2018年11月16日(星期五) 下午3:49
>> *收件人:* "user"<us...@kylin.apache.org>;
>> *主题:* 大神，求助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?
>>
>>
>>
>> ------------------------------
>> 742093703@qq.com
>>
>