kylin-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From 宋海涛 <hts...@gaojihealth.com>
Subject 答复: 回复: 答复: Re: Kylin Count(col) Result Is Different With Hive
Date Fri, 26 Oct 2018 01:29:32 GMT
Hi 

 

Is this configuration kylin.query.enable-dynamic-column  work for you?

I set it in project level, but it didn’t’ work for me. 

 

Is there anyone else tried this?  

 

Thanks. 

 

发件人: May Zhou [mailto:may.a.zhou@foxmail.com] 
发送时间: 2018年10月23日 16:53
收件人: user
主题: 回复: 答复: Re: Kylin Count(col) Result Is Different With Hive

 

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

 

 

------------------ 原始邮件 ------------------

发件人: "Ma Gang"<mg4work@163.com>;

发送时间: 2018年10月23日(星期二) 下午4:47

收件人: "user"<user@kylin.apache.org>;

主题: 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 kylin.properties 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" <may.a.zhou@foxmail.com> wrote:



Hi Shaofeng,

   I didn't find this configuration parameter in the configuration list via
https://kylin.apache.org/docs/install/configuration.html, 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.



 

 

BRs,

May

   

 

 

------------------ 原始邮件 ------------------

发件人: "ShaoFeng Shi"<shaofengshi@apache.org>;

发送时间: 2018年10月23日(星期二) 下午3:51

收件人: "user"<user@kylin.apache.org>;

主题: 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 <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-k
ylin-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