kylin-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ShaoFeng Shi <shaofeng...@apache.org>
Subject Re: 答复: Re: Kylin Count(col) Result Is Different With Hive
Date Tue, 23 Oct 2018 07:51:02 GMT
One suggestion, such new feature should be enabled by default; Otherwise,
most people won't know it, even we add it to the configuration list...

Ma Gang <mg4work@163.com> 于2018年10月23日周二 下午3:17写道:

> You may set the configuration 'kylin.query.enable-dynamic-column' to true
> in kylin.properties, and test it.
>
>
> At 2018-10-23 15:15:00, " 宋海涛" <htsong@gaojihealth.com> wrote:
>
> Hi Ma Gang,
>
>
>
>    Thank you for your reply.   The column ‘fzy_bill_code’ is from fact
> table.
>
>    But what do you mean about ‘enable dynamic column configuration.”
>
>
>
> Thanks.
>
>
>
> *发件人:* Ma Gang [mailto:mg4work@163.com]
> *发送时间:* 2018年10月23日 15:04
> *收件人:* user@kylin.apache.org
> *主题:* Re:Re: Kylin Count(col) Result Is Different With Hive
>
>
>
> Is the column '*fzy_bill_code*' from fact table? If so, the issue should
> have been fixed in https://issues.apache.org/jira/browse/KYLIN-3360, you
> need to enable dynamic column configuration.
>
>
>
>
> At 2018-10-23 14:11:46, "you Zhuang" <zhuangzixiaoyou@gmail.com> wrote:
>
>
> http://apache-kylin.74782.x6.nabble.com/about-count-a-particular-column-in-kylin-td5579.html
>
>
>
> On 23 Oct 2018, at 10:27 AM, Haitao SONG <htsong@gaojihealth.com> wrote:
>
>
>
>
>
> 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
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>


-- 
Best regards,

Shaofeng Shi 史少锋

Mime
View raw message