You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@kylin.apache.org by "胡志华 (万里通科技及数据中心商务智能团队数据分析组)" <HU...@pingan.com.cn> on 2016/11/03 09:14:39 UTC

答复: 答复: how to modify kylin.cube.aggrgroup.max.combination

I modified it to 2*31 , and put the it the middle of the file, it works

By the way, I don't know the default value, and kylin.properties doesn't contain it by default

-----邮件原件-----
发件人: ShaoFeng Shi [mailto:shaofengshi@apache.org] 
发送时间: 2016年11月3日 16:48
收件人: dev
主题: Re: 答复: how to modify kylin.cube.aggrgroup.max.combination

The value need be an integer, but 4294967296 is too big I guess; why not just double or triple the default value?

2016-11-03 14:27 GMT+08:00 胡志华(万里通科技及数据中心商务智能团队数据分析组) <
HUZHIHUA160@pingan.com.cn>:

> HI shaofeng,
>
>         After adding " kylin.cube.aggrgroup.max.combination= 4294967296"
> at the end of kylin.properties, I can 't find cube info in WEB UI, 
> kylin.log shows as below
>
> “2016-11-03 14:18:58,215 ERROR [localhost-startStop-1]
> cube.CubeManager:880 : Error during load cube instance, skipping :
> /cube/txn_cube_1010.json
> java.lang.IllegalStateException: CubeInstance desc not found 
> 'TXN_CUBE_1010', at /cube/txn_cube_1010.json”
>    After deleting " kylin.cube.aggrgroup.max.combination= 4294967296", 
> it go back normal.
>
> -----邮件原件-----
> 发件人: ShaoFeng Shi [mailto:shaofengshi@apache.org]
> 发送时间: 2016年11月3日 14:03
> 收件人: dev
> 主题: Re: how to modify kylin.cube.aggrgroup.max.combination
>
> set in conf/kylin.properties
>
> 2016-11-03 13:54 GMT+08:00 胡志华(万里通科技及数据中心商务智能团队数据分析组) <
> HUZHIHUA160@pingan.com.cn>:
>
> > Hi all,
> >
> >        How to modify “kylin.cube.aggrgroup.max.combination”? When 
> > analyst  build cube which dimensions exceed 16, kylin will tell 
> > error,and advise us to update “kylin.cube.aggrgroup.max.combination”
> > to a bigger value. But I can ‘t find anywhere to update,
> > $KYLIN_HOME/conf???
> >
> >
> >
> >
> >
> >
> >
> > ************************************************************
> > ********************************************************************
> > The information in this email is confidential and may be legally 
> > privileged. If you have received this email in error or are not the 
> > intended recipient, please immediately notify the sender and delete 
> > this message from your computer. Any use, distribution, or copying 
> > of this email other than by the intended recipient is strictly 
> > prohibited. All messages sent to and from us may be monitored to 
> > ensure compliance with internal policies and to protect our business.
> > Emails are not secure and cannot be guaranteed to be error free as 
> > they can be intercepted, amended, lost or destroyed, or contain 
> > viruses. Anyone who communicates with us by email is taken to accept
> these risks.
> >
> > 收发邮件者请注意:
> > 本邮件含保密信息,若误收本邮件,请务必通知发送人并直接删去,不得使用、传播或复制本邮件。
> > 进出邮件均受到本公司合规监控。邮件可能发生被截留、被修改、丢失、被破坏或包含计算机病毒等不安全情况。
> > ************************************************************
> > ********************************************************************
> >
>
>
>
> --
> Best regards,
>
> Shaofeng Shi 史少锋
>
> ************************************************************
> ********************************************************************
> The information in this email is confidential and may be legally 
> privileged. If you have received this email in error or are not the 
> intended recipient, please immediately notify the sender and delete 
> this message from your computer. Any use, distribution, or copying of 
> this email other than by the intended recipient is strictly 
> prohibited. All messages sent to and from us may be monitored to 
> ensure compliance with internal policies and to protect our business.
> Emails are not secure and cannot be guaranteed to be error free as 
> they can be intercepted, amended, lost or destroyed, or contain 
> viruses. Anyone who communicates with us by email is taken to accept these risks.
>
> 收发邮件者请注意:
> 本邮件含保密信息,若误收本邮件,请务必通知发送人并直接删去,不得使用、传播或复制本邮件。
> 进出邮件均受到本公司合规监控。邮件可能发生被截留、被修改、丢失、被破坏或包含计算机病毒等不安全情况。
> ************************************************************
> ********************************************************************
>



--
Best regards,

Shaofeng Shi 史少锋

********************************************************************************************************************************
The information in this email is confidential and may be legally privileged. If you have received this email in error or are not the intended recipient, please immediately notify the sender and delete this message from your computer. Any use, distribution, or copying of this email other than by the intended recipient is strictly prohibited. All messages sent to and from us may be monitored to ensure compliance with internal policies and to protect our business.
Emails are not secure and cannot be guaranteed to be error free as they can be intercepted, amended, lost or destroyed, or contain viruses. Anyone who communicates with us by email is taken to accept these risks.

收发邮件者请注意:
本邮件含保密信息,若误收本邮件,请务必通知发送人并直接删去,不得使用、传播或复制本邮件。
进出邮件均受到本公司合规监控。邮件可能发生被截留、被修改、丢失、被破坏或包含计算机病毒等不安全情况。
********************************************************************************************************************************

Re: 答复: 答复: how to modify kylin.cube.aggrgroup.max.combination

Posted by ShaoFeng Shi <sh...@apache.org>.
the default value is 4096 (2^12); in the future kylin will show them in the
kylin.properties;

2016-11-03 17:14 GMT+08:00 胡志华(万里通科技及数据中心商务智能团队数据分析组) <
HUZHIHUA160@pingan.com.cn>:

> I modified it to 2*31 , and put the it the middle of the file, it works
>
> By the way, I don't know the default value, and kylin.properties doesn't
> contain it by default
>
> -----邮件原件-----
> 发件人: ShaoFeng Shi [mailto:shaofengshi@apache.org]
> 发送时间: 2016年11月3日 16:48
> 收件人: dev
> 主题: Re: 答复: how to modify kylin.cube.aggrgroup.max.combination
>
> The value need be an integer, but 4294967296 is too big I guess; why not
> just double or triple the default value?
>
> 2016-11-03 14:27 GMT+08:00 胡志华(万里通科技及数据中心商务智能团队数据分析组) <
> HUZHIHUA160@pingan.com.cn>:
>
> > HI shaofeng,
> >
> >         After adding " kylin.cube.aggrgroup.max.combination= 4294967296"
> > at the end of kylin.properties, I can 't find cube info in WEB UI,
> > kylin.log shows as below
> >
> > “2016-11-03 14:18:58,215 ERROR [localhost-startStop-1]
> > cube.CubeManager:880 : Error during load cube instance, skipping :
> > /cube/txn_cube_1010.json
> > java.lang.IllegalStateException: CubeInstance desc not found
> > 'TXN_CUBE_1010', at /cube/txn_cube_1010.json”
> >    After deleting " kylin.cube.aggrgroup.max.combination= 4294967296",
> > it go back normal.
> >
> > -----邮件原件-----
> > 发件人: ShaoFeng Shi [mailto:shaofengshi@apache.org]
> > 发送时间: 2016年11月3日 14:03
> > 收件人: dev
> > 主题: Re: how to modify kylin.cube.aggrgroup.max.combination
> >
> > set in conf/kylin.properties
> >
> > 2016-11-03 13:54 GMT+08:00 胡志华(万里通科技及数据中心商务智能团队数据分析组) <
> > HUZHIHUA160@pingan.com.cn>:
> >
> > > Hi all,
> > >
> > >        How to modify “kylin.cube.aggrgroup.max.combination”? When
> > > analyst  build cube which dimensions exceed 16, kylin will tell
> > > error,and advise us to update “kylin.cube.aggrgroup.max.combination”
> > > to a bigger value. But I can ‘t find anywhere to update,
> > > $KYLIN_HOME/conf???
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > ************************************************************
> > > ********************************************************************
> > > The information in this email is confidential and may be legally
> > > privileged. If you have received this email in error or are not the
> > > intended recipient, please immediately notify the sender and delete
> > > this message from your computer. Any use, distribution, or copying
> > > of this email other than by the intended recipient is strictly
> > > prohibited. All messages sent to and from us may be monitored to
> > > ensure compliance with internal policies and to protect our business.
> > > Emails are not secure and cannot be guaranteed to be error free as
> > > they can be intercepted, amended, lost or destroyed, or contain
> > > viruses. Anyone who communicates with us by email is taken to accept
> > these risks.
> > >
> > > 收发邮件者请注意:
> > > 本邮件含保密信息,若误收本邮件,请务必通知发送人并直接删去,不得使用、传播或复制本邮件。
> > > 进出邮件均受到本公司合规监控。邮件可能发生被截留、被修改、丢失、被破坏或包含计算机病毒等不安全情况。
> > > ************************************************************
> > > ********************************************************************
> > >
> >
> >
> >
> > --
> > Best regards,
> >
> > Shaofeng Shi 史少锋
> >
> > ************************************************************
> > ********************************************************************
> > The information in this email is confidential and may be legally
> > privileged. If you have received this email in error or are not the
> > intended recipient, please immediately notify the sender and delete
> > this message from your computer. Any use, distribution, or copying of
> > this email other than by the intended recipient is strictly
> > prohibited. All messages sent to and from us may be monitored to
> > ensure compliance with internal policies and to protect our business.
> > Emails are not secure and cannot be guaranteed to be error free as
> > they can be intercepted, amended, lost or destroyed, or contain
> > viruses. Anyone who communicates with us by email is taken to accept
> these risks.
> >
> > 收发邮件者请注意:
> > 本邮件含保密信息,若误收本邮件,请务必通知发送人并直接删去,不得使用、传播或复制本邮件。
> > 进出邮件均受到本公司合规监控。邮件可能发生被截留、被修改、丢失、被破坏或包含计算机病毒等不安全情况。
> > ************************************************************
> > ********************************************************************
> >
>
>
>
> --
> Best regards,
>
> Shaofeng Shi 史少锋
>
> ************************************************************
> ********************************************************************
> The information in this email is confidential and may be legally
> privileged. If you have received this email in error or are not the
> intended recipient, please immediately notify the sender and delete this
> message from your computer. Any use, distribution, or copying of this email
> other than by the intended recipient is strictly prohibited. All messages
> sent to and from us may be monitored to ensure compliance with internal
> policies and to protect our business.
> Emails are not secure and cannot be guaranteed to be error free as they
> can be intercepted, amended, lost or destroyed, or contain viruses. Anyone
> who communicates with us by email is taken to accept these risks.
>
> 收发邮件者请注意:
> 本邮件含保密信息,若误收本邮件,请务必通知发送人并直接删去,不得使用、传播或复制本邮件。
> 进出邮件均受到本公司合规监控。邮件可能发生被截留、被修改、丢失、被破坏或包含计算机病毒等不安全情况。
> ************************************************************
> ********************************************************************
>



-- 
Best regards,

Shaofeng Shi 史少锋