change "kylin.cube.aggrgroup.max.combination" to 8092 isn't enough for your case, because you're trying to put 18 dimensions into one aggregation group, with 4 hierarchyes (each has 3 dim); You can calculate the combination numbers beyond of 8092; You can see some detail info in the log.
Kylin makes this check is telling user not to put too many dimensions into one agg group; if you do need do so, try your best to leverage the optimizations to reduce the combinations; Otherwise, the cube may explode too much. My suggestion is trying to divide your dimensions into multiple groups based on the query patterns. 2016-05-11 19:22 GMT+08:00 Mars J <[email protected]>: > Hi ShaoFeng, > > My former manipulation is to set : > kylin.cube.aggrgroup.max.size=24 > kylin.cube.aggrgroup.max.combination=8092 > and restart kylin server,but it didn't work. > > I update the properties to values as follow just now: > kylin.cube.aggrgroup.max.size=48 > kylin.cube.aggrgroup.max.combination=16384 > > and then restart kylin server, it can crerate cube successfully. > > Now, I don't know what is the appropriate value to set it and this two > properties stand for what ? > > 2016-05-11 19:15 GMT+08:00 Mars J <[email protected]>: > >> Yes, I have restart kylin server after update this property. but the >> error is still there. >> >> 2016-05-11 17:20 GMT+08:00 ShaoFeng Shi <[email protected]>: >> >>> Hi Mars, did you restart kylin server after update this property? >>> >>> 2016-05-11 16:34 GMT+08:00 Mars J <[email protected]>: >>> >>>> Hi, >>>> I'm creating a cube, at the "Advanced Setting" step, I have 18 >>>> columns in the Agg Group includes like the picture below: >>>> [image: 内嵌图片 2] >>>> >>>> when save this cube , it shows the error message as follow: >>>> >>>> [image: 内嵌图片 1] >>>> >>>> then I go to edit kylin.properties to alter the value of >>>> kylin.cube.aggrgroup.max.combination, but I didn't find the default value >>>> of this property. I think this property is meaning of the number of include >>>> number in agg group. I found the default value from github is 4096, and I >>>> set it to 8092, also has this error. >>>> >>>> Please tell me what the right meaning of >>>> kylin.cube.aggrgroup.max.combination and how to set it can avoid my error. >>>> >>>> Thanks. >>>> >>> >>> >>> >>> -- >>> Best regards, >>> >>> Shaofeng Shi >>> >>> >> > -- Best regards, Shaofeng Shi
