kylin-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Zhong, Yanghong" <>
Subject Re: 回复: 答复: Re: Kylin Count(col) Result Is Different With Hive
Date Tue, 23 Oct 2018 08:58:02 GMT
The config ‘kylin.query.enable-dynamic-column’ cannot currently work on the cube level,
since for a sql, only project is specified and we don’t know which cube will serve the sql.

Best regards,
Yanghong Zhong

From: May Zhou <>
Reply-To: "" <>
Date: Tuesday, October 23, 2018 at 4:53 PM
To: user <>
Subject: 回复: 答复: Re: Kylin Count(col) Result Is Different With Hive

Thanks Allen, it do work by overwriting in the Project Level. :)

------------------ 原始邮件 ------------------
发件人: "Ma Gang"<>;
发送时间: 2018年10月23日(星期二) 下午4:47
收件人: "user"<>;
主题: Re:回复: 答复: Re: Kylin Count(col) Result Is Different With Hive

I don't think the configuration can be override in cube level, you need to set it in the
file or in the project's config, and you don't need to rebuild the cube.
At 2018-10-23 16:01:25, "May Zhou" <> wrote:

Hi Shaofeng,
   I didn't find this configuration parameter in the configuration list via,
could you help to check that?

Besides, could this configuration be overwritten in the Cube Level? I tried this configuration
in the Cube level, but it did not works on the result of count(column). Moreover, I re-builded
this cube also, but it did not work still.


------------------ 原始邮件 ------------------
发件人: "ShaoFeng Shi"<<>>;
发送时间: 2018年10月23日(星期二) 下午3:51
收件人: "user"<<>>;
主题: Re: 答复: Re: Kylin Count(col) Result Is Different With Hive

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 <<>> 于2018年10月23日周二 下午3:17写道:
You may set the configuration 'kylin.query.enable-dynamic-column' to true in,
and test it.

At 2018-10-23 15:15:00, " 宋海涛" <<>>

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.”


发件人: Ma Gang [<>]
发送时间: 2018年10月23日 15:04
主题: 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<>,
you need to enable dynamic column configuration.

At 2018-10-23 14:11:46, "you Zhuang" <<>>

On 23 Oct 2018, at 10:27 AM, Haitao SONG <<>>

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 史少锋

View raw message