Right, putting 125 dimensions on fact table to one cube is crazy; Usually when dimension > 12, you need do some optimization to control the combination numbers (by default combination number = 2^N, N is the number of dimensions).
2017-03-29 15:04 GMT+08:00 Fan Xie <fan....@kyligence.io>: > > Hi suresh, currently kylin could not handle fact table with 125 dimensions > yet. Normal we suggest users to build cubes with no more than 16 > dimensions. You can refer to this blog : http://kylin.apache.org/ > docs20/howto/howto_optimize_cubes.html to learn how to reduce the > dimensions number of your cube. > > > ________________________________ > 发件人: suresh m <suresh.m8...@gmail.com> > 发送时间: 2017年3月29日 14:01:31 > 收件人: dev@kylin.apache.org > 主题: Re: Is there any limitation of columns in Fact table in kylin > > Hi Could you please respond on this very urgent for me. > > Regards, > Suresh > > On Tue, Mar 28, 2017 at 7:13 AM, suresh m <suresh.m8...@gmail.com> wrote: > > > Hi, > > > > > > One of my fact table contains 125 columns and while creating the cube > > showing attached error. > > > > Please let me know, is there any limitation on columns and how to resolve > > this issue. > > > > > > > -- Best regards, Shaofeng Shi 史少锋
