Suppose you have N dimensions, and all in one agg group, then the total cuboid will be 2^N. But if you split N into N1, N2, N3, which N1+N2+N3>=N, then the total cuboid will be 2^N1+2^N2+2^N3. You will figure out how improvement this could be.
How to split the agg groups depends on how your query would be. Maybe you could share with us what kinds of query it is. 2016-12-09 11:44 GMT+08:00 peter zhang <[email protected]>: > I build a cube. First time, without any tuning and no aggregation group > setting, cube size is about 20G. > Then refer tuning document, I add some aggregation group, cube is deduced > to 71.02 MB. Unfortunately, query performance is also worse than before, > most of the query latency is about more than 10 seconds. > I don't know what the different between add all columns in one new agg > group and split columns group into different group. In my practice, I > created 6 agg-group. > > Any guys can help check my json schema > > Thanks in advance. > >
