what's the combination's meaning ? what's the relation between number of combination and number of dimensions ?
2016-05-11 22:35 GMT+08:00 ShaoFeng Shi <[email protected]>: > 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 > >
